1. 字段如果不设置auto_increment和default的值,是不允许插入表的。
2. insert into student(id, name) values("1", "2");
3. 还有一种insert反式,insert into student set id = "1", name = "2";
4. 更新表一些字段 update student set id = "1", name = "2" where sex = "female";
1. 字段如果不设置auto_increment和default的值,是不允许插入表的。
2. insert into student(id, name) values("1", "2");
3. 还有一种insert反式,insert into student set id = "1", name = "2";
4. 更新表一些字段 update student set id = "1", name = "2" where sex = "female";