/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

0 vote156 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote207 views1 answer
Mssql check if date is greater than today
SQL
1 vote226 views1 answer
Mysql strict_trans_tables
SQL
-1 vote256 views1 answer
Difference berween database and data base management system
SQL
0 vote210 views1 answer
Install sql server windows 10
SQL
1 vote213 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote195 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote227 views2 answers
Update query with between in mysql
SQL
0 vote221 views2 answers
Get item by composite primary key mysql
SQL
0 vote189 views1 answer
How to connect pgadmin with excel
SQL