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

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.