本来呢,在这个表查询,要在最后边字段下面添加数据
使用update,insert是插入数据的,不是修改数据的,可以把男女id分别拿出来,这样修改
update exam_result set sex='男' where id in(1,2,3);
update exam_result set sex='女' where id in(4,5,6);
https://www.cnblogs.com/nmsghgnv/p/12369656.html
https://blog.csdn.net/vample/article/details/84955590
https://blog.csdn.net/xiaosongbk/article/details/65446351
https://blog.csdn.net/weixin_42345642/article/details/100972408
https://blog.csdn.net/qq_43546676/article/details/89043445
https://www.jianshu.com/p/6bd6869631d9
https://zhuanlan.zhihu.com/p/33816647