table_schema 数据库名 如果不写库名会查询所有的库
table_name 替换成自己的表名
column_name 替换成自己的列名
存在返回1
不存在返回2
select CASE when (select count(1)
FROM information_schema.COLUMNS
WHERE table_schema = 'table_schema'
and table_name = "table_name "
AND column_name = "column_name " ) > 0
then '1'
else '2'
end
DROP PROCEDURE
IF
EXISTS script;
--
DELIMITER //
CREATE PROCEDURE script() BEGIN
/*
* table_schema 数据库名
* table_name 表名
* column_name 字段名
*/
if not exists ( SELECT 1 FROM information_schema.COLUMNS WHERE table_schema = 'a_shoushan' AND table_name = 'device' AND column_name = 'coal_yield' )
then
ALTER TABLE device ADD COLUMN coal_yield VARCHAR ( 50 ) COMMENT '过煤量/进尺';
end if;
END;
//
CALL script();
--