/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 vote136 views1 answer
Top 3 salary in sql
SQL
0 vote138 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote132 views1 answer
Min mysql
SQL
0 vote142 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote142 views1 answer
Trigger vérifier stock
SQL
0 vote128 views2 answers
Mysql set foreign_key_checks=0
SQL
25 votes127 views1 answer
Mysql grant all privileges to a user
SQL
0 vote197 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote129 views1 answer
Influxdb export to csv
SQL
3 votes146 views1 answer
Postgres add not null to existing column
SQL