DROP PROCEDURE IF EXISTS add_tb_column;
DELIMITER $$
CREATE PROCEDURE add_tb_column()
BEGIN
DECLARE CurrentDatabase VARCHAR(100);
SELECT DATABASE() INTO CurrentDatabase;
IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=CurrentDatabase
AND TABLE_NAME='utsCPTY_BANK_ADT'
AND COLUMN_NAME='BelongBankCode' )
THEN
ALTER TABLE utsCPTY_BANK_ADT ADD COLUMN BelongBankCode VARCHAR(50);
END IF;
END;
CALL add_tb_column;
Mysql 可重复执行添加字段脚本
最新推荐文章于 2024-03-26 16:04:36 发布