MySQL数据操纵

最新推荐文章于 2022-05-07 23:26:29 发布

原创最新推荐文章于 2022-05-07 23:26:29 发布 · 290 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

学习MySQL 专栏收录该内容

15 篇文章

订阅专栏

本文详细介绍了SQL语言中插入、更新、删除和替换等操作的具体用法，包括常见的语法错误及解决方案，通过实例展示了如何使用SQL进行数据管理。

插入数据
INSERT：

insert into stu (stuID,stuName,stuSex,stuBirth,stuSchool) values ('20160111001','张晓雯','女','1997-08-17','飞行技术学院');

遇到个问题解决一下：https://blog.youkuaiyun.com/yabingshi_tech/article/details/51010047

insert into stu values ('20160211011','李雪梅','女','1','1997-07-19','交通运输学院'),('20160310022','张志斌','男','1','1998-07-10','航空工程学院');

insert into stu set stuID='20160411033',stuName='王雪蕊',stuSex='女',stuBirth = '1997-05-17',stuSchool = '外国语学院';
select * from stu;

 use student;
 create table xsxx(xh varchar(11),xb varchar(2));
 insert into xsxx select stuID,stuSex from stu;
 select * from xsxx;

REPLACE:

insert into stu values('20160111001','王小强','男','1','1997-08-17','飞行技术学院');
error;(竟然没报错。。。)
replace into stu values('20160111001','王小强','男','1','1997-08-17','飞行技术学院');

删除数据
delete:

delete from xsxx where xb='男';

delete from xsxx order by xh desc limit 2;

truncate:

truncate table xsxx;

修改数据：
update:

 update stu set stuSex='女',stuBirth='1998-08-17' where stuID='20160111001';
 update stu set stuSchool='飞行技术学院' limit 3;
 update score set score=score-2 where courseID='E2201040' order by score desc limit 2;

update stu,score set stu.Stuschool = '计算机学院',score.score=score.score-5 where stu.stuID=score.stuID and stu.stuID='20160111001';