sql中数据处理：

一.添加新数据！
插入单行记录
1.create table box(
name varchar(30) not null,
id int not null primary key,
student varchar(20),
gender char(2) default 0 comment '0男：1女'
);
insert into box(name, id, student) values('xiaohong',123,'123'),('bingxin',565,'334');
select*from box;
插入新数据：insert into 表名（列名）values (列表参数)也可加，（列表参数）；
插入多行数据：insert into <表名> select <select语句>
insert into games select year+12,city from games;
insert inti Students (studenyname,studenyid) select studenyname+2,studenyid from Students.
二.更新新数据。
1.update 表名 set 要改的值 where <过滤的条件>
create table box3(
name varchar(30) not null,
id int not null primary key,
student varchar(20),
gender char(2) default 0 comment '0男：1女'
);
insert into box3(name, id, student) values('minxing',365,'668'), ('lunxun',778,'388');

update set box3 name='xiaotao',id='596' where student='668';
delete from box3 where id='365' and student='388';
select*from box3;
2.删除数据
delete from 表名 where <过滤条件>
delete from box3 where id='596';
delete from box3 where id='335'and/or name='xiaotao';

 

 

一。查询的基本结构：
select 列
from 表名
where （过滤的）
group by 以....来分组
having 判定...条件
order by（排序）asc升序，desc降序
二：
查找：select 列名 from表名
select name,student,subject from box;
取别名：select name'姓名' ，subject'奖项' from box；
返回限定行数查询：
select top 5 student from box(查询第一条到第五条)
三模糊查询：
select *from box where limit 0,4(o是从0行开始，4是指长度)
select*from box where like '%liu%';
select age from student order by age desc limit 0,8;

转载于:https://www.cnblogs.com/ba1314/p/4058289.html