2DHSjZeV

1delimiter '//'
2
3CREATE PROCEDURE addcol() BEGIN
4IF NOT EXISTS(
5	SELECT * FROM information_schema.COLUMNS
6	WHERE COLUMN_NAME='new_column' AND TABLE_NAME='the_table' AND TABLE_SCHEMA='the_schema'
7	)
8	THEN
9		ALTER TABLE `the_schema`.`the_table`
10		ADD COLUMN `new_column` bigint(20) unsigned NOT NULL default 1;
11
12END IF;
13END;
14//
15
16delimiter ';'
17
18CALL addcol();
19
20DROP PROCEDURE addcol;