UPDATE `dbAAA`.`tbAAA` SET `C` = '1' WHERE `A` = 'ec';
UPDATE `dbAAA`.`tbAAA` SET `C` = '1' WHERE `A` = 'dg';
UPDATE `dbAAA`.`tbAAA` SET `C` = '1' WHERE `A` = 'yn';
一次性操作
UPDATE `dbAAA`.`tbAAA` SET `C` = '1' WHERE `A` IN ('ec','dg', 'yn');
转载于:https://www.cnblogs.com/lovewyc1314/p/6109615.html