The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

DELETE syntax error

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?

Answer Answered by Ian Gilfillan in this comment.

The syntax in the original question in incorrect, but LIMIT and GROUP BY can be used in DELETE in certain cases. See DELETE.

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.