以下的文章主要介绍的是MYSQL DELETE语法的实际操作步骤以及对MYSQL DELETE语法的实际应用代码的描述,以下就是对其具体内容描述,希望会给你带来一些帮助在学习此语法方面。
单表语法:
- DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
- [WHERE where_definition]
- [ORDER BY ...]
- [LIMIT row_count]
多表语法:
- DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
- tbl_name[.*] [, tbl_name[.*] ...]
- FROM table_references
- [WHERE where_definition]
或:
- DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
- FROM tbl_name[.*] [, tbl_name[.*] ...]
- USING table_references
- [WHERE where_definition]
tbl_name中有些行满足由where