测试mysql语句

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') THENALTER TABLE `ims_yao_conf` ADD sharecontent varchar(100);END IF;