/SQL/Create column that already exists mysql

Create column that already exists mysql

DROP PROCEDURE IF EXISTS `?`;
DELIMITER //
CREATE PROCEDURE `?`()
BEGIN
  DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
  ALTER TABLE `table_name` ADD COLUMN `column_name` INTEGER;
END //
DELIMITER ;
CALL `?`();
DROP PROCEDURE `?`;

Source: stackoverflow.com

Similar codes

2 votes392 views1 answer
Dbms transaction (psql)
SQL
0 vote366 views1 answer
How to search query in python3 sqlite3
SQL
0 vote402 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote364 views1 answer
Linebreak sql
SQL
0 vote395 views1 answer
Oracle current timestamp insert statement
SQL
0 vote386 views1 answer
Mysql limit order by
SQL
0 vote378 views1 answer
Postgresql auto increment not working
SQL
10 votes387 views4 answers
SELECT FROM WHERE
SQL
3 votes562 views6 answers
Sql unique select
SQL
0 vote372 views1 answer
Shell script to log mysql cpu usage
SQL