sql: DBの操作

  • XAMPP
  • ALTER USER IDENTIFIED
  • CREATE DATABASE
  • CREATE TABLE
  • CREATE USER
  • DELETE
  • DROP USER
  • GRANT
  • INSERT INTO
  • UPDATE

sql: データの抽出

  • SELECT
  • GROUP BY
  • LIMIT
  • ORDER BY
  • WHERE
  • WHERE 1=1

sql: 演算子

  • 算術演算子
  • 比較演算子
  • 論理演算子
  • AS
  • BETWEEN
  • IS NOT NULL
  • IS NULL
  • LIKE

sql: 関数

  • AVG
  • CAST
  • CEILING
  • CONCAT
  • COUNT
  • FLOOR
  • IN
  • LAST_DAY
  • LENGTH
  • LOWER
  • MAX
  • MIN
  • MOD
  • NOT IN
  • POSITION
  • RAND
  • ROUND
  • SUBSTRING
  • SUM
  • SYSDATE
  • TRIM
  • UPPER