数据库的增删改查

1.创建数据库

CREATE DATABASE xxx;

2.查看建好的数据库

SHOW DATABASES;

3.在数据库中建表,查询

CREATE TABLE xxx;

整表查询 Select * from 表名;
查询表中某些列 Select 列名 from 表名;
筛选列表的不重复内容 Select distinct 列表名 from 表格名;
筛选表格中部分内容 Select * from 表名 where 条件;
条件查询in select * from t_user where name in (“张三”, “李四”,“王麻子”);

and/or
select * from t_user where year>16 and name in (“张三”, “李四”);
select * from t_user where year>16 or name in (“张三”, “李四”);

select between
select name from t_user where year between 20 and 28;

查询升序/降序排列
select * from t_user oder by year desc;
select * from t_user oder by year asc;

多表查询
select * from book as a left jion price as b on a.id=b.id;

4.查看当前数据库中的表

SHOW TABLES;

5.数据库中信息的增、删、改、查

INSERT INTO XXX VALUES();
DELETE FROM XXX WHERE XX;
UPDATE XXX SET XX=X WHERE XXXX;
SELECT * FROM XXX;

到这里，对数据库的简单操作就完成啦！