MYSQL基本操作命令

1. 查询

查询数据项数

select count(*) from 'table name'

查询数据项数

数据操作

DELETE

单表语法：

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT row_count]

Reference