Product Solutions Support
Try MemSQL

DELETE

Deletes data from a table.

Syntax

DELETE FROM tbl_name
    [WHERE expr]
    [LIMIT row_count]

Remarks

Example

memsql> DELETE FROM mytbl WHERE seq=1;
Query OK, 3 rows affected (0.04 sec)

memsql> DELETE FROM mytbl WHERE id IN (SELECT id from myother) LIMIT 10;
Query OK, 10 rows affected (0.02 sec)
Was this article useful?