/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

3 votes311 views4 answers
Show columns from table
SQL
1 vote361 views1 answer
Backup mysql schema only
SQL
0 vote310 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote332 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote346 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote348 views1 answer
Mysql disable triggers
SQL
0 vote302 views1 answer
Update row in sqlite python
SQL
16 votes402 views3 answers
Get count of duplicate records
SQL
-1 vote324 views1 answer
Mac mysql workbench console
SQL
1 vote300 views1 answer
Sql update table remove spaces
SQL