Comments - DELETE syntax error
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The syntax would be correct if it were a SELECT command. LIMIT is not for use with DELETE...much like ORDER BY and GROUP BY.
The syntax in the original question in incorrect, but LIMIT and GROUP BY can be used in DELETE in certain cases. See DELETE.