一、所要的效果
表里有一个字段【零件编号】,该编号为需要引用count方法,我们想象的写法:
INSERT INTO 零件信息表(名称,厂商,零件编号,价格)VALUES('变速箱','陶伊尔',COUNT(*)+1,550)
先上正确的写法:
INSERT INTO 零件信息表(名称,厂商,零件编号,价格)
SELECT '变速箱','陶伊尔',COUNT(*)+1,550 FROM 零件信息表
以上是会报错的。
二、正确的处理逻辑
-(1)用select拉取需要插入的数据
-(2)把刚才拉取的数据插入到表中
(1)select拉取 数据
(2)把刚才的数据insert into某个表中
INSERT INTO VR_TEACHER(
vr_username,
vr_teacher_id,
vr_teacher_name,
vr_teacher_photo,
vr_teacher_sex,
vr_teacher_des,
vr_teacher_major,
vr_teacher_phone,
vr_teacher_qq,
vr_teacher_mail,
vr_teacher_cdate,
del_flag
)
SELECT
'T20220928',
COUNT(*)+1,
'测试号',
'photo',
1,
'描述',
'专业',
'13708718888',
'8802535',
'dzj@qq.com',
DATETIME() ,
0
FROM VR_TEACHER
三、测试
红色的记录为新添加的记录