DELETE syntax error

You are viewing an old version of this question. View the current version here.

DELETE bsbp FROM b_sale_basket_props AS bsbp INNER JOIN b_sale_basket AS bsb ON bsbp.BASKET_ID = bsb.ID LEFT JOIN b_sale_fuser AS bsf ON bsf.ID = bsb.FUSER_ID WHERE bsf.DATE_UPDATE < '2020-02-17 00:00:00' AND bsf.USER_ID IS NULL AND bsb.ORDER_ID IS NULL LIMIT 100;

Error message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 100' at line 11!

Version SQL DB: 5.5.54-MariaDB

The syntax is correct. What is the error about?


Comments loading...
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.