今天在做一个功能的时候用到了,数据表列名检查。网上查阅,接收了下新知识。记录分享---
不多说,直接上sql语句:
declare vTableName,vCurrentDatabase varchar(50);
declare vEmpConfirmState varchar(15);
set vTableName = json_extract(datas,'$.tableName');
select database() into vCurrentDatabase;
if not exists (select * from INFORMATION_SCHEMA.COLUMNS where table_name = vTableName and column_name = 'empConfirmState') then
set rlt= concat('{"success":false,"msg":"<font style= color:red><b>警告:该模块没有需员工确认项...</b></font>"}');
end if;
也欢迎登录我的个人网站,里面有更多的文章及技术咨询在等你:http://www.guangmuhua.com