mysql delete syntax

最新推荐文章于 2022-06-18 10:01:28 发布

原创最新推荐文章于 2022-06-18 10:01:28 发布 · 139 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #Java

mysql 专栏收录该内容

23 篇文章

订阅专栏

本文详细介绍了MySQL中DELETE语句的单表及多表删除语法。包括LOW_PRIORITY、QUICK、IGNORE等选项的作用，以及WHERE子句、ORDER BY和LIMIT的应用。通过本文，读者可以掌握如何精确地从数据库中删除所需的数据。


Single-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

Multiple-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]
Or:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    FROM tbl_name[.*] [, tbl_name[.*]] ...
    USING table_references
    [WHERE where_condition]