- 创建数据库
create database demo1;
- 切换到某个数据库
use demo1;
- 创建表
create table test(id varchar(20),name varchar(20),age varchar(20),addr varchar(20));
- 展示表
show tables;
- 向test表插入数据
insert into test values(‘1001’,’zhangsan’,’20’,’chizhou’);
insert into test values(‘1002’,lisi,’21’,anqing);
insert into test values(‘1003’,wangwu,’19’,hefei);
insert into test values(‘1004’,zhouliu,’20’,shanghai);
insert into test values(‘1005’,zhaoqi,’18’,wuhu);
- 数据库增删改查操作
- 查询全部:select * from test;
- 条件查询:select * from test where id=’1001’;
- 修改(将id为1002的addr为anqing的修改为beijing):update test set addr=’beijing’ where id=’1002’;(修改完成后可以select * from test;确认一下是否修改成功)
- 插入数据: insert into test values(‘1006’,’maer’,’20’,’suzhou’);(插入完成后可以select * from test;确认一下是否插入成功)
- 删除数据: delete from test where id=’1003’;(删除完成后可以select * from test;确认一下是否删除成功)
- 排序(按照age降序升序排序):select * from test order by age;
select * from test order by age desc;