最後更新: 2018-12-10
介紹
- Comment
- PRIMARY 與 UNIQUE Key 分別
- INSERT
- DELETE
- SELECT
- UPDATE
- LIMIT
- DB (CREATE, DROP)
- Table (Create, Drop)
- Show(tbl, db, permission)
- Clone Tables
- CHARSET
- DISTINCT
- Group By
- ORDER BY
- JOIN
- FOREIGN KEY
- TMP Table
- Sub-Queries
- INCREMENT
- TRUNCATE tablename 與 Delete from tablename
- 解決 username 有 duplicate
-
計算
- DIV() - TMP table Usage
- INCREMENT
- 解決 username 有 duplicate
- VIEW
- Show PROCEDURE, FUNCTION, TRIGGERS
- FOREIGN KEY
- ON DUPLICATE KEY UPDATE
- 找出同一 transaction_id 內多隻 record
- 找出會員最後一次購買記錄