MySQL参数化执行SQL

SET @columnExists1 = (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE()
        AND TABLE_NAME='csh_periodcourse' AND COLUMN_NAME = 'BadgePoint');
SET @mysql1 = IF (@columnExists1 = 0, 'ALTER TABLE `csh_periodcourse` ADD COLUMN `BadgePoint` int NULL;', 'select \'Column Exists\' status');
PREPARE stmt1 FROM @mysql1;
EXECUTE stmt1;

SET @columnExists2 = (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE()
        AND TABLE_NAME='eval_processevaldetail' AND COLUMN_NAME = 'CalculateBadgeCount');
SET @mysql2 = IF (@columnExists2 = 0, 'ALTER TABLE `eval_processevaldetail` ADD COLUMN `CalculateBadgeCount` int NULL;', 'select \'Column Exists\' status');
PREPARE stmt2 FROM @mysql2;
EXECUTE stmt2;

SET @columnExists3 = (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE()
        AND TABLE_NAME='eval_processevaldetail' AND COLUMN_NAME = 'ExtraBadgeCount');
SET @mysql3 = IF (@columnExists3 = 0, 'ALTER TABLE `eval_processevaldetail` ADD COLUMN `ExtraBadgeCount` int NULL;', 'select \'Column Exists\' status');
PREPARE stmt3 FROM @mysql3;
EXECUTE stmt3;

INSERT ignore INTO Frm_GlobalSettings (KeyCode, KeyValue, Module, SchoolId, Description, IsSuperAdminOnly, ValueType, Id) VALUES ('HasBadge', '', 'GeneralConfigInfo',(SELECT id FROM Bas_school), '徽章(龙娃贴)', 1, 'Bool', '4ea7d42a-71c5-41b7-9186-24605a383db3');