数据库增删改查简单指令

1. 插入数据

全表插入
insert into person values('Tom',18);

指定字段插入
insert into person(name)values('Jerry');

批量插入
insert into person values('Lucy',58),('Lily',59);

insert into person(name) values('Lilei'),('Hanmeimei')

中文问题

set names gbk;

输入后可以查看中文

2. 简单查询

查询所有数据
select * from person;

查询所有名字
select name from person;

select * from person where age>50;

3. 修改数据

修改person表，姓名为jerry年龄为30
update person set age=30 where name='Jerry';

update person set age=20 where age is null;

4. 删除数据

delete from person where age=20;

delete from person where name='Tom';

delete from person;