DROP DELETE 命令

1、删除数据库

DROP DATABASE [IF EXIST] 数据库名

2、删除表

DROP TABLE [IF EXIST] 表名 [,表名, ...]

DELETE 命令

DELETE [LOW_PRIORITY] [QUICK] FROM table_name

[WHERE where_definition]

[ORDER BY ...]

[LIMIT rows]

DELETE [LOW_PRIORITY] [QUICK] table_name[.*] [, table_name[.*] ...]

FROM table-references

[WHERE where_definition]

DELETE [LOW_PRIORITY] [QUICK]

FROM table_name[.*] [, table_name[.*] ...]

USING table-references

[WHERE where_definition]