mysql sql delete别名问题
时间:2022-03-14 02:45
MYSQL的delete语句不支持别名!要使用别名需要在delete后也使用别名
如:
delete from test t where t.id in (1,2);(执行失败)
select t.* from test t where t.id in (1,2);(执行成功)
时间:2022-03-14 02:45
MYSQL的delete语句不支持别名!要使用别名需要在delete后也使用别名
如:
delete from test t where t.id in (1,2);(执行失败)
select t.* from test t where t.id in (1,2);(执行成功)