常用的Sql命令之插入数据

 

1、向表lianxi2插入数据

insert into lianxi2(id,uname,idoxu) values("1","hanhan","2018"),("2","hanhan2","2018")
insert into lianxi2(id,uname,sex) values("11","hanhan3","1"),("12","hanhan4","2"),("13","hanhan5","1"),("14","hanhan6","2")

2、向表lianxi3插入数据

insert into lianxi3(id,stu_id,c_name,grade)values("4","11","xiaoming","90"),("5","12","xioahua","100"),("6","33","xiaoli","20")