SQLメモ
主なデータ型
- CHARACTER : 'hoge'
- NATIONAL CHARACTER : N'ほげ'
- NUMERIC : 1
- DATE : DATE'1999-12-31'
データ検索
- SELECT [field]... FROM [table] フィールドの検索
- [field] -> * : 全列指定, SELECT DISTINCT 重複の省略, SELECT ALL 重複の表示
- SELECT ... FROM ... WHERE [condition] 条件付き検索
- WHERE [value] (NOT) BETWEEN A AND B
- WHERE [value] (NOT) IN([value(s)]...)
- WHERE [value] LIKE [pattern] ESCAPE [char] あ...