sql删除不能别名?
其实是语法差异:
-- 没有别名时候的语法:
DELETE from t_user where tdate='2020-05-29';
-- 有别名时候的语法:
DELETE t from t_user t where t.tdate='2020-05-29';
sql删除不能别名?
其实是语法差异:
-- 没有别名时候的语法:
DELETE from t_user where tdate='2020-05-29';
-- 有别名时候的语法:
DELETE t from t_user t where t.tdate='2020-05-29';