我不能在sql delete中使用别名

sqlfiddele here: http://sqlfiddle.com/#!2/b2771推荐答案如果您使用的是别名...您必须告诉实际删除的内容(可能是因为通常只需要表别名 在多表语法中...您可以完全省略别名):If you're using aliases... ÿou have to tell what to actually delete (probably this is because table aliases are usually only needed in multiple table syntax... you could just omit the alias altogether):mysql> delete from tablename r;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r' at line 1mysql> delete r from tablename r;Query OK, 0 rows affected (0.00 sec)请参见ALS 手册: 注意 如果为表声明别名，则在引用表时必须使用别名: 从测试AS t1，test2的地方删除t1 ... Note If you declare an alias for a table, you must use the alias when referring to the table: DELETE t1 FROM test AS t1, test2 WHERE ... 这篇关于我不能在sql delete中使用别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 1403页，肝出来的..