/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

8 votes141 views1 answer
Sql limit results returned
SQL
3 votes149 views2 answers
Df to sql pandas sql achemy
SQL
0 vote143 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote141 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes145 views1 answer
Data types in sql
SQL
0 vote149 views1 answer
Oracle query to find schema you are working on
SQL
3 votes169 views3 answers
Mysql auto increment after delete
SQL
0 vote139 views1 answer
Postgresql interview questions
SQL
0 vote127 views1 answer
How to create an SQL save method in ruby
SQL
0 vote148 views1 answer
Mysql zerofill
SQL