·排序
增序
SELECT * from table ORDER BY Id ASC;
降序
SELECT * from table ORDER BY Id DESC;
·不重复的用户名查询出来了
select distinct name from table;
·查看数据库:
show databases;
·创建数据库:
create database db1 DEFAULT CHARSET utf8 COLLATE utf8_general_ci; # utf8编码
create database db1 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; # gbk编码
·使用数据库:
use db1;
·增
insert into 表 (列名,列名…) values (值,值,…)
insert into 表 (列名,列名…) values (值,值,…),(值,值,值…)
insert into 表 (列名,列名…) select (列名,列名…) from 表
·删
delete from 表 # 删除表里全部数据
delete from 表 where id=1 # 删除ID =1 那一行数据
·改
update 表 set name = ‘aaa’ where id>14
·查
select * from 表