desc student;
-- 给指定的列名赋值
insert into student(id,name) values(1,"张三");
SELECT * from student;-- 查询表内容
-- 给全部的列名 赋值
insert into student(id,name,gender,birthday,score,email,tel,status) VALUES(4,'张三','男','2000-12-10',89.32,'166832234@qqcom','1784410798',1);
INSERT INTO student (id,NAME,gender,birthday,score,email,tel,STATUS) VALUES (3,'李四','男','1999-11-11',88.88,'lisi@itcast.cn','13888888888',1);
-- 省略格式
INSERT INTO student VALUES (2,'李四','男','1999-11-11',88.88,'lisi@itcast.cn','13888888888',1);
-- 批量添加数据
insert INTo student VALUES(5,'小台','男','2000-07-01',99.00,'234627@dwjh','84782-272',2),
(6,'小王','男','2000-06-21',79.00,'234627@dwjh','84782-272',1),
(7,'小红','女','2003-07-11',79.00,'234627@dwjh','84782-272',0),
(8,'小花','女','2004-07-01',79.00,'234627@dwjh','84782-272',1),
(9,'小王','男','2019-06-21',79.00,'234627@dwjh','84782-272',1);
-- 修改表数据 修改是必须加以条件 否则全部修改
update student set name = '王五' WHERE id = 2 ;
update student set gender = '男', birthday = '1999-12-12', score = 99.99 ,email = '136183@uwqe' ,tel = '38743632234', status = 0 where name = '张三';
-- 删除表数据 DELETE FROM 表名 [WHERE 条件] ;
delete from student where name = '李四';
-- 删除表中所有数据 delete from 表名
delete from student
【mysql 增加数据、查询数据、修改数据、删除数据语句】
最新推荐文章于 2024-04-20 20:34:04 发布