1. obclient> DELETE FROM t1 WHERE c1 = 2;
    2. Query OK, 1 row affected (0.02 sec)
    4. obclient> SELECT * FROM t1;
    5. +----+------+
    6. | c1 | c2   |
    7. +----+------+
    8. |  1 |    1 |
    9. |  3 |    3 |
    10. |  4 |    4 |
    11. +----+------+
    • 单表删除，删除表 t2 的 p2 分区的数据。
    1. obclient> DELETE FROM t2 PARTITION(p2);
    2. Query OK, 3 rows affected (0.02 sec)
    4. obclient> SELECT * FROM t2;
    5. +----+------+
    6. | c1 | c2   |
    7. +----+------+
    8. |  5 |    5 |
    9. +----+------+
    10. 1 row in set (0.02 sec)
    • 多表删除，删除 t1、t2 表中 “t1.c1 = t2.c1” 的数据。
    1. obclient> DELETE FROM t1, t2 USING t1, t2 WHERE t1.c1 = t2.c1;
    4. obclient> SELECT * FROM t1;
    5. +----+------+
    6. | c1 | c2   |
    7. +----+------+
    8. |  4 |    4 |
    9. +----+------+
    10. 1 row in set (0.01 sec)
    12. obclient> SELECT * FROM t2;