DML-操作数据-添加

 

 

-- 代码选中之后右击运行已选择的就可以单行执行代码
-- 查询所有数据 
SELECT * from stu;
-- 给指定列添加数据 INSERT INTO 表名(列名1，列名2，...) VALUES(值1，值2，...);
INSERT INTO stu(id,name) VALUES(1,'张三');
-- 给所有列添加数据
INSERT into stu(id,name,sex,birthday,score,email,tel,state) VALUES(2,'李四','男','1999-11-11',88.88,'lisi@itlll.com','17865656565',1);
-- 简化，省略列名
INSERT into stu VALUES(2,'李四','男','1999-11-11',88.88,'lisi@itlll.com','17865656565',1);
-- 批量添加
INSERT into stu(id,name,sex,birthday,score,email,tel,state) VALUES(3,'李四','男','1999-11-11',88.88,'lisi@itlll.com','17865656565',1),
(3,'李四','男','1999-11-11',88.88,'lisi@itlll.com','17865656565',1),(3,'李四','男','1999-11-11',88.88,'lisi@itlll.com','17865656565',1);