SQL语言-数据更新操作
1.在教学管理数据库jxgl中,使用MySQL Workbench在表中导入表5-1和表5-2的数据
将所给数据导入student表:
insert into student
values ('2005010','赵春江',18,'男','Cs'),
('2005011','赵丽萍',19,'女','Ch'),
('2005012','陈景欢',20,'男','Is'),
('2005013','陈婷婷',16,'女','Ph'),
('2005014','李军',16,'女','Ph');
导入后查看结果:
将所给数据导入sc表:
insert into sc
values ('2005010','1',87),
('2005010','2',NULL),
('2005010','3',80),