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

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

MySQL Delete when prompt syntax error! The following sql:

When you remove a table alias:

The correct wording for example:

DELETE from Comments_report where  EXISTS (SELECT 1 from            COMMENTS              where COMMENTS. Commentid=comments_report. Commentid and COMMENTS. Postid= ' 00001 ');

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!!!