Mysql常用语句
注：Mysql语句中，只有库名，表名和字段名才使用小引号，其余字符串均用普通引号;
WGOL顺序原则：where, group by, order by 和 limit
1、添加语句（3种）：
1 INSERT INTO FROM `表名` ( `字段1`,`字段2`,...,`字段n` ) VALUES ( '值1','值2',...,'值n' ); 2 INSERT INTO FROM `表名` ( '值1','值2',...,'值n'); 3 INSERT INTO FROM `表名` SET `字段1`='值1',`字段2`='值2',...,`字段n`='值n';
2、删除语句：
DELETE FORM `表名` ( where字句，遵循WGOL原则);
例：DELETE FROM `NEWS` WHERE `ID` = 1;【删除NEWS表中ID=1的数据】
3、修改语句：
UPDATE `表名` SET `字段1`='值1',`字段2`='值2',...,`字段n`='值n';
4、查询语句：
1 查询所有字段：SELECT * FROM `表名`; 2 查询指定字段：SELECT `字段1`,`字段2`,...,`字段n` FROM `表名`; 3 带条件查询：SELECT `字段1`,`字段2`,...,`字段n` WHERE 查询条件; 4 (查询条件运算符有：<, =, >, <=, >=, <>[不等于], and, or) 5 模糊查询： 6 (1)like 匹配查询 7 SELECT * FROM `表名` WHERE '条件' LIKE '%要匹配的值%'; 8 SELECT * FROM `表名` WHERE '条件' NOT LIKE '%要匹配的值%'; 9 (2)in 包含查询 10 SELECT * FROM `表名` WHERE '条件' IN ('值1','值2',...); 11 SELECT * FROM `表名` WHERE '条件' NOT IN ('值1','值2',...); 12 (3)GROUP BY 分类查询 13 SELECT * FROM `表名` WHERE '条件'` GROUP BY `字段`; 14 (4)ORDER BY 顺序查询 15 SELECT * FROM `表名` WHERE '条件' GROUP BY `字段` ASC|DESC; 16 (5)LIMIT 限制查询 17 SELECT * FROM `表名` WHERE '条件' LIMIT 起始位，条数; 18 (注：起始位若省略不写，默认从0开始，0为第一条数据)
