jatubio on 01/19/11
Last Edited at 01/19/11 10:13pm
delimiter '//' CREATE PROCEDURE addcol() BEGINIF NOT EXISTS( SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME='new_column' AND TABLE_NAME='usuarios' AND TABLE_SCHEMA='the_schema' ) THEN ALTER TABLE `the_schema`.`the_table` ADD COLUMN `new_column` bigint(20) unsigned NOT NULL default 1; END IF;END;// delimiter ';' CALL addcol(); DROP PROCEDURE addcol;
Report this snippet Tweet
Comment:
You need to login to post a comment.