Mysql02——CRUD
Insert
解释:
1.“abc”添加到int型的会报错,而“123”则可以,因为mysql在底层会尝试类型转换,可以转换则成功
4.双引号也可以
6.
7.如果一共三列,添加时values里写三个对应的就可以省略列名,如果不匹配的话就要指定列名
8.
Update
注意第三点 慎重不加where 除非真的想修改所有数据
delete
INSERT INTO `employee` VALUES(3,"假李四","男","1997-06-29","1999-05-26 18:56:23","律师助手",2000,"法外狂徒小弟");
DELETE FROM employee WHERE `name`="假李四";
select
集合可以写 in(10,20,30)
上面是显示总分
本文来自博客园,作者:紫英626,转载请注明原文链接:https://www.cnblogs.com/recorderM/p/15876835.html