-- 代码选中之后右击运行已选择的就可以单行执行代码 -- 查询所有数据 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);