1、insert语句
INSERT INTO cold_address_character
AS a (a.applyerId
) VALUES (235);
执行错误
不用别名
INSERT INTO cold_address_character
( applyerId
) VALUES (235);
执行正确
2、update语句
取别名
UPDATE cold_address_character
AS a SET a.applyerId
= ‘2’ WHERE a.applyerId
= ‘1’;
执行正确
3、delete语句
DELETE FROM cold_address_character
a WHERE a.id = 1
执行错误
DELETE FROM cold_address_character
WHERE id = 1
执行正确
参考
https://blog.csdn.net/cainiaodejiaobu/article/details/77160123