/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 vote186 views1 answer
Mysql date format unix timestamp
SQL
0 vote174 views1 answer
MySQL INSERT IGNORE Statement
SQL
3 votes230 views2 answers
Update part of a string in mysql
SQL
0 vote185 views1 answer
Get last date join sql
SQL
0 vote176 views1 answer
Oracle right characters
SQL
9 votes214 views1 answer
Identity insert on sql server
SQL
1 vote194 views1 answer
Sql current timestamp
SQL
1 vote223 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote136 views1 answer
Oracle list all stored procedures
SQL
0 vote189 views1 answer
Compare if is null sql
SQL