/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 vote274 views1 answer
Date datatype in livesql
SQL
1 vote256 views1 answer
Mysql check table exists
SQL
21 votes257 views4 answers
Add column mssql
SQL
0 vote261 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote266 views1 answer
Rails run native ssql query
SQL
0 vote260 views1 answer
Show table details postgresql
SQL
0 vote255 views1 answer
Equi joins in oracle
SQL
1 vote251 views1 answer
Postgresql last element of array
SQL
0 vote262 views1 answer
Sql cnvert bit to nvarchar
SQL
4 votes255 views1 answer
Mysql not equal
SQL