MySql新增列的时候判断是否存在 [数据库教程]

Z时代
2024-01-10
分类：综合

database

dropprocedureifexists schema_change;
delimiter ‘;;‘;
createprocedure schema_change() begin
ifnotexists( select*from information_schema.`COLUMNS` where TABLE_NAME=‘QYTB_DYAQ‘and COLUMN_NAME=‘BDCQYWBSM‘) then
altertable QYTB_DYAQ add BDCQYWBSM CHAR(1);
endif;
end;;
delimiter ‘;‘;
-- 调用存储过程
call schema_change(); 
dropprocedureifexists schema_change;