create table datamanage(
id int auto_increment primary key,
name varchar(20),
age varchar(20)
);
–建一个测试表
create table datamanage2(
id int auto_increment primary key,
name varchar(20),
age varchar(20)
);
–建一个测试表2
insert into datamanage(id,name,age)values(1000,'bohu',25);
–在该表增加一条数据,字符串需要用单引号
insert into datamanage values(1001,'qiuxiang',19);
–可以省略字段名插入一条完整数据
insert into datamanage(id,name) values(1002,'wuzhuangyuan');
–插入一条不完整数据
insert into datamanage(id,name,age)
values(1003,'huataishi',55),
(1004,'shusheng',40),
(1005,'zhuzhishan',29)
–插入多条数据
insert into datamanage
values(1006,'huawen',16),
(1007,'huawu',15),
(1008,'duichuanchang',39)
–省略字段名插入多条数据
insert into datamanage(name,age)
values('ruhua',25),
('ningwang',41),
('huafuren',35)
–插入不完整数据,但是观察结果可以发现,id字段受主键自增约束影响,自动分别赋值了1009、1010、1011
insert into datamanage2(name,age)
select name,age
from datamanage;
–将一个表的查询结果插入到另一个表中,id字段也通过主键自增赋值了,不过是从1开始的
update datamanage set age=38
where name='wuzhuangyuan';
–根据条件修改数据记录
update datamanage set age=18;
–无限定条件将更新全表该对应数据
update datamanage set
id='9527',
name='tangbohu',
age='25'
where id='1000';
–修改一条记录的多列数据
update datamanage set age=17
where age<19;
–另一种条件示范
delete from datamanage
where name='huafuren';
–根据条件删除一条记录
delete from datamanage
–不加条件将删除该表全部记录