Sqlite Basic Knowledge

  1. Date Types

    1. TEXT INTEGER NUMERIC REAL NONE

    2. String Datatypes -All string datatypes in SQLite are converted to a TEXT datatype. If you try to specify a size for a string datatype, SQLite will ignore it, as it does not allow size restrictions on string datatypes.

    3. Numeric Datatypes - All numeric datatypes in SQLite are converted to INTEGER, NUMERIC, or REAL datatypes.

    4. Date/Time Datatypes - All date or time datatypes in SQLite are converted to NUMERIC datatypes.

    5. Large Object (LOB) Datatypes - NONE

  2. Command Line

    1. Meta Commands

    CommandDescription
    .showDisplays current settings for various parameters
    .databasesProvides database names and files
    .quitQuit sqlite3 program
    .tablesShow current tables
    .schema/ .fullschemaDisplay schema of table
    .headerDisplay or hide the output table header
    .modeSelect mode for the output table
    .dumpDump database in SQL text format

  3. CRUD

    1. Create

    2. Read(Select)

    3. Update

    4. Delete

  4. Reference

    1. Getting Started with SQLite3 – Basic Commands

标签: none

添加新评论