/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

1 vote269 views1 answer
Sql alchemy with azuresql server
SQL
0 vote308 views1 answer
Pagination with row_number
SQL
0 vote282 views1 answer
SQL column name Oracle
SQL
0 vote302 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote254 views1 answer
Mssql current date
SQL
0 vote283 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote273 views1 answer
Add multiple field in table sql
SQL
11 votes279 views2 answers
How to import mysql database command line
SQL
6 votes261 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote251 views1 answer
Mysql error codeigniter
SQL