IF NOT EXISTS (SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='ims_yao_conf' AND table_schema = 'sharecontent') THEN
ALTER TABLE `ims_yao_conf` ADD sharecontent varchar(100);
END IF;
测试mysql语句
最新推荐文章于 2015-07-08 21:17:53 发布