mysql数据库鸡础查询（ikun版）

`student`INSERT INTO student(id,NAME) VALUES(1,'蔡徐坤');
SELECT * FROM student;
CREATE TABLE student4(
	id INT,
	NAME VARCHAR(20),
	age INT,
	sex VARCHAR(5),
	address VARCHAR(100),
	math INT,
	english INT


);
DESC student4;
INSERT INTO student4(id,NAME,age,sex,address,math,english)VALUES(1,'蔡徐坤',22,'男','北京',66,88),(2,'鸡哥',99,'女','上海',44,99),(3,'坤哥',3,'男','广州',22,34),(4,'只因坤',22,'男','杭州',66,88),(5,'鸡坤',22,'男','深圳',66,88),(6,'张正号',20,'男','西安',80,60);
SELECT * FROM student4;
-- 查询姓名和年龄
SELECT NAME,age FROM student4;
-- 查询去除重复的结果集
SELECT DISTINCT address FROM student4;
SELECT NAME,math,english,math+english FROM student4
-- 如果只有null参与的运算，计算结果都为null解决方法如下
SELECT NAME,math,english,math+IFNULL(english,0) FROM student4;-- ifnull 如果english==null则将english赋值为0;
SELECT NAME,math,english,math+IFNULL(english,0)AS 总分 FROM student4;
 SELECT * FROM student4 WHERE age >=20; 
 SELECT *FROM student4;
 -- null不能使用=判断null要使用is/is not判断
 -- 模糊查询使用like查询
 -- 查询姓鸡的人 
 SELECT * FROM student4 WHERE NAME LIKE '鸡%';
 -- 查询第二个是哥的人
 SELECT * FROM student4 WHERE NAME LIKE '_哥';
 -- 查询姓名是三个字的人
  SELECT * FROM student4 WHERE NAME LIKE '___';
  -- 查询姓名中包含鸡的人;
   SELECT * FROM student4 WHERE NAME LIKE '%鸡%';