INSERT INTO `user`(id,`name`,age) VALUES(5,'孙越',23);
#DEFAULT或不写: 自增 有默认值 可以为空
INSERT INTO `user`(id,`name`,age) VALUES(DEFAULT,'孟鹤堂',23);
INSERT INTO `user`(`name`,age) VALUES('郭麒麟',DEFAULT);
INSERT INTO `user`(`name`,age) VALUES('李纯',DEFAULT);
#删除操作 慎用 刑事责任 (where)
DELETE FROM student
#有条件删除 非null判断 is < > = !=
DELETE FROM `user` WHERE age is null
#修改操作 [where]
UPDATE `user` SET age=33 where name='郭麒麟'
#修改多个
UPDATE `user` SET age=12,name='闫鹤翔' WHERE `name`='郭麒麟'
#查询操作 *通配符 count(*)查询纪录数 [where]
SELECT * FROM `user`
#where 条件
#比较运算符 = > < >= <= != <>不等于
SELECT * FROM `user` WHERE age is null
# is (=) 空不空 is not (!=)
SELECT * FROM `user` WHERE age is not null
#逻辑运算符 AND(&) or(|) not(!)
SELECT * FROM `user` WHERE id>1 and age<30
SELECT * FROM `user` WHERE id<5 or age<30
SELECT * FROM `user` WHERE not id=3
#区间判断 BETWEEN
SELECT * FROM `user` WHERE id BETWEEN 1 and 3
#范围判断 in
SELECT * FROM `user` WHERE id in (1,3,5,8)
#模糊判断 %:若干个字符(可以表示一个或多个 没有)
SELECT * FROM `user` WHERE name LIKE '%张%'
# _ 表示一个
SELECT * FROM `user` WHERE name LIKE '%云_'