msqly
SELECT * FROM game;
SELECT * FROM 王者荣耀.game AS a;
SELECT 类型 FROM game;
SELECT DISTINCT 类型 FROM game;
SELECT DISTINCT c.类型 AS b FROM 王者荣耀.game AS c;
SELECT * FROM game WHERE 类型 ='法师';
SELECT * FROM game WHERE 类型 LIKE '法师';
SELECT * FROM game WHERE 类型 ='法师' AND 等级 >30;
SELECT * FROM game WHERE 类型 ='法师' OR 等级 >60;
SELECT * FROM game WHERE 等级 BETWEEN 60 AND 80;
SELECT * FROM game WHERE 等级 >=60 AND 等级 <=80;
SELECT 等级,姓名 FROM game;
SELECT * FROM game WHERE 姓名 LIKE '李%'
SELECT * FROM game WHERE 姓名 LIKE '%小_'
SELECT * FROM game WHERE 姓名 LIKE '%信%'
SELECT * FROM game WHERE 姓名 LIKE '__信'
SELECT 等级 *10 AS 'aa' FROM game;
SELECT 编号 *等级 AS 'aa' FROM game;
SELECT * FROM game WHERE 类型 !='法师';
SELECT * FROM game WHERE NOT 类型 ='法师';
SELECT * FROM game WHERE NOT 类型 IN ('法师');
SELECT * FROM game WHERE NOT 等级 <=60;
SELECT * FROM game WHERE 类型 ='null';
SELECT * FROM game WHERE NOT 类型 ='null';
SELECT * FROM game WHERE 姓名 IN ('李白','李广','武则天');
SELECT * FROM game WHERE 姓名 ='李白' OR 姓名 ='李广' OR 姓名 ='武则天';
更多相关文章
- 关于Go语言,你可能会讨厌的五件事
- MySQL字符类型datetime与timestamp
- mysql中生成列与JSON类型的索引
- mysql的数据类型和字符集
- 商家寄件运力接口-查询全国快递公司运力覆盖情况的案例代码
- SpringMVC_Day01
- python学习随笔-数据类型
- $()的四种类型; jQuery方法;jQuery对象转js对象的方法----0413
- 一文读懂java中的Reference和引用类型