MySQL入門

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 ASC
  SELECT * FROM `TABLE` WHERE col = 'val' ORDER BY DESC