Need some help? Ask here.

ASK A QUESTION.

Thanks for taking the time to reach out to us! We take support and feedback extremely seriously and will get back to you as soon as possible.

Delete Syntax¶

MemSQL supports the following DELETE syntax:

DELETE FROM tbl_name
    [WHERE where_condition]
    [LIMIT row_count]

Note

MemSQL does not currently support multi-table DELETE statements.

DELETE queries will fail if there are concurrent ALTER TABLE, CREATE INDEX, or DROP INDEX statements running on the table, or if maximum_table_memory limit has been reached.

Previous topic

Next topic