/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 votes200 views1 answer
Sql server current date minus 5 years
SQL
0 vote159 views1 answer
Sql table to store status
SQL
0 vote172 views1 answer
Sequelize postgresql schema
SQL
0 vote207 views1 answer
Oracle insert single quote in string
SQL
0 vote182 views1 answer
Show create table in postgresql
SQL
0 vote208 views1 answer
Sql where time stamp is in between
SQL
33 votes186 views6 answers
Sql delete
SQL
0 vote232 views1 answer
Table structure in sql
SQL
1 vote319 views1 answer
Postgres set column based on another column
SQL
0 vote170 views1 answer
Running query in redshift
SQL