mysql 修饰语句_mysql语句

mqsql基本操作

查询：

1、SELECT * FROM 表名称 SELECT * FROM (finance_risk.white_user_info) WHERE (ssoid="2000051590" AND white_level="L0000")

2、SELECT DISTINCT 列名称 FROM 表名称 SELECT DISTINCT (white_level FROM finance_risk.`white_user_info`)查询white_level列返回唯一不同的值

3、SELECT * FROM 表名称 ORDER BY 列名 SELECT * FROM finance_risk.`white_user_info` ORDER BY (create_time DESC)按照create_time列进行倒叙排序

若在mysql中实现select top功能得用：select * from tablename limit M,N这里M表示从(M+1)条记录开始，N表示返回的记录条数，如下

4、SELECT * FROM 表名称 LIMIT 5查询指定的行 SELECT * FROM finance_risk.`white_user_info` WHERE imei = '868380038018930' ORDER BY id DESC LIMIT 0,100 按照id进行倒叙排序，输出1-100行数据

5、IN的用法 SELECT * FROM finance_risk.`white_user_info` WHERE ssoid IN ('2000051590','2000051593')

6、LIKE 操作符(%多个字符，_ 一个字符) SELECT * FROM finance_risk.`white_user_info` WHERE ssoid LIKE '2%'

7、BETWEEN 和NOT BETWEEN操作符 SELECT * FROM finance_risk.`white_user_info` WHERE create_time BETWEEN '2018-10-24 10:56:48' AND '2020-01-05 12:56:24'

更新：UPDATE (finance_risk.white_user_info)表 SET white_level(更新列) = 'L0001'(更新值) WHERE (white_level = 'L0000'AND ssoid='2000051590')查询条件

删除：

1、DELETE FROM 表名称 WHERE 列名称 = 值

插入

2、INSERT INTO 表名称 VALUES (值1, 值2,....) INSERT INTO finance_risk.'white_user_info'(ssoid) VALUE('1234567')