DROP PROCEDURE IF EXISTS pro_AddColumn;
DELIMITER //
CREATE PROCEDURE pro_AddColumn()
BEGIN
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name='tb_table' AND COLUMN_NAME='test_key') THEN
ALTER TABLE tb_table ADD COLUMN test_key VARCHAR(64) not NULL AFTER id;
END IF;
End //
DELIMITER ;
CALL pro_AddColumn();
DROP PROCEDURE pro_AddColumn;
DELIMITER ; 分号前有个空格,这个要注意下(尚未有时间进行检验是否必须了)