hello goodbye

SQLITE

6 月 17th, 2008 | by admin |

current_timestampだとグリニッジ標準時間を取得してしまうので

datetime(’now’, ‘localtime’)

auto_incrementはINTEGER PRIMARY KEYと宣言することで可能。

型

NULL      The value is a NULL value.
INTEGER   The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8
            bytes depending on the magnitude of the value.
REAL      The value is a floating point value, stored as an 8-byte IEEE
             floating point number.
TEXT      The value is a text string, stored using the database encoding
            (UTF-8, UTF-16BE or UTF-16-LE).
BLOB      The value is a blob of data, stored exactly as it was input.