-- insert 添加数据
select * from teacher;
-- 添加表中的所有列
insert into teacher values(null,'daimenglaoshi','高级');
-- 添加部分列
insert into teacher(tname) values('wanglaoshi');
insert into teacher values(null,'zhanglaoshi','高级');
insert into student values(null,'lisi',default,556777,null,101);
insert into student values(null,'wangwu',default,888888,null,102);
insert into student values
(null,'zhaoliu',default,99999,null,101),
(null,'王二',default,77777,null,102);
数据库 数据的插入 SQL
最新推荐文章于 2024-08-01 09:46:22 发布