【查询语句】
SELECT * FROM table_name where key = value
【插入语句】
INSERT INTO table_name (key1,key2,key3) VALUES (value1,value2,value3)
【更新语句】
UPDATE table_name SET key1 = value1,key2 = value2 WHERE key1 = value1
【删除语句】
DELETE FROM table_name WHERE key = value
【分页语句】
SELECT * FROM table_name LIMIT 10,5
【排序语句】
//DESC-升序 ASC-降序
SELECT * FROM table_name ORDER BY id DESC
【分组语句】
SELECT * FROM table_name GROUP BY key1,key2
【统计数量语句】
SELECT COUNT(*) FROM table_name
【关联语句】
SELECT * FROM table_name1 JOIN table_name2 on (table_name1.table_id = table_name2.id)