1、造数据,把lianxi2表所有数据,插入到lianxi3表字段,取值规则:
id取id
stu_id取uname
istester取grade字段,给默认值60
insert into lianxi3(id,stu_id,c_name,istester,grade) select id,id,uname,60,60 from lianxi2
1、造数据,把lianxi2表所有数据,插入到lianxi3表字段,取值规则:
id取id
stu_id取uname
istester取grade字段,给默认值60
insert into lianxi3(id,stu_id,c_name,istester,grade) select id,id,uname,60,60 from lianxi2