按常理MySQL使用别名删除时会报错,比如删除user(别名为 u)表中id=1的记录:
DELETE FROM
user
u WHERE u.id=1;
报错:
必须使用下面的语句删除:
> DELETE u FROM user
u WHERE u.id=1;
按常理MySQL使用别名删除时会报错,比如删除user(别名为 u)表中id=1的记录:
DELETE FROM
user
u WHERE u.id=1;
报错:
必须使用下面的语句删除:
> DELETE u FROM user
u WHERE u.id=1;