1. 查询数据
SELECT column_name,column_name FROM table_name [WHERE Clause] [LIMIT N][ OFFSET M]
2. 插入数据
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );
3. 更新数据
UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
4. 删除记录
DELETE FROM table_name [WHERE Clause]
5. 创建表
CREATE TABLE table_name (column_name column_type);
6. 删除表
DROP TABLE table_name ;