Table aliases are not supported when you delete data from MySQL database

Today, I'm helping colleagues. View a deleted SQL statement execution error

The SQL statements are as follows:

1 DELETE from Lead_system_menu_org_ref as T WHERE t.resourceid= ' 4028812348f28b890148f29253a80000 '

This SQL statement can be executed in the Oracle database, but the following error occurred when it was placed in the MySQL database:

1 [ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' WHERE t.resourceid= ' 40288 12348f28b890148f29253a80000 '

See "SQL Syntax" know SQL execution error because SQL syntax is not correct, this is more strange, this deleted SQL look at the vertical look no problem ah, Oracle can execute normally, why MySQL does not, the Internet to check the reason, The original is the MySQL database delete data, does not support table aliases, this problem has not been noted before, this record.

Table aliases are not supported when you delete data from MySQL database