/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

15 votes144 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote119 views1 answer
Unique vs distinct sql
SQL
2 votes150 views1 answer
Change primary key sql
SQL
0 vote160 views1 answer
Sql column contains special character
SQL
0 vote153 views1 answer
Longtext sql
SQL
4 votes195 views1 answer
Rename stored procedure in sql server
SQL
3 votes191 views3 answers
Create table in SQL Server
SQL
2 votes150 views1 answer
Sql find missing values between two tables
SQL
8 votes204 views1 answer
Mysql dump restore
SQL
0 vote153 views1 answer
Mysql repair a table
SQL