资料库分类
SQL(关联式资料库): MySQL,MSSQL,PostgreSQL...NOSQL(非关联式资料库): MongoDB,OrientDB,ElasticSearch...PHPMyAdmin
DB
建立资料库
CREATE DATABASE `DBname`
删除资料库
DROP DATABASE `DBname`
查看已建立的资料库
SHOW DATABASES
Table
查询
SELECT * FROM `TABLE`SELECT * FROM `TABLE` WHERE col = 'val'
排序
ORDER BY
ASC (递增)DESC (递减)SELECT * FROM `TABLE` WHERE col = 'val' ORDER BY ASCSELECT * FROM `TABLE` WHERE col = 'val' ORDER BY DESC