常用到的SQL语句 ：）

1）根据某个条件在该表查询对应的数据
SELECT * FROM table WHERE FIELD = value;

2）用“like”查询
SELECT * FROM table WHERE field LIKE “value”;

3）优选选择
SELECT * FROM table LIMIT 数值 ;

4）插入
INSERT INTO table(field) VALUES (value)；

5）删除
DELETE FROM table WHERE field=value；

6）更新
UPDATE table SET field = value WHERE 条件 ；

7）总数
SELECT COUNT(字段) AS totalcount FROM table ；

8）求和
SELECT SUM(字段) AS sumvalue FROM table;

9）平均
SELECT AVG(字段) AS avgvalue FROM table;

10）最大值
SELECT MAX(字段) AS ‘MAXVALUE’ FROM table; 或者 SELECT MAX(字段) ‘MAXVALUE’ FROM table;

11）最小值
SELECT MIN(字段) ‘minvalue’ FROM table；

12）根据某字段出现量排序
select field from table group by 共用的字段 having count(共用的字段 ) >1;

13）where连接条件查询 in链接
SELECT * FROM table WHERE field1 in (SELECT field1 FROM table WHERE field2=“value”);

14）left join on 以左表为基准 right join on 以右表为基准 inner join on 只返回两个表中联结字段相等的行
SELECT * FROM table1 a LEFT JOIN table2 b ON a.field1 = b.field1;
SELECT * FROM table1 a RIGHT JOIN table2 b ON a.field1 = b.field1;
SELECT * FROM table1 a INNER JOIN table2 b ON a.field1 = b.field1;

15）between 在两个值之间
SELECT * FROM table WHERE field between ‘value1’ AND ‘value2’ ;

16）not between
SELECT field1,field2 FROM table WHERE field1/field2 not between ‘value1’ AND ‘value2’ ;

17） in 包括/不包括
SELECT * FROM table WHERE field in (‘value1’,‘value2’);
SELECT * FROM table WHERE field NOT in (‘value1’,‘value2’);

18）四表查询
SELECT * FROM yivi_user_cash a LEFT JOIN yivi_user_account b ON a.user_id = b.user_id RIGHT JOIN yivi_user_address c ON a.user_id = c.user_id FULL JOIN yivi_sys_user d ON a.user_id = d.user_id;