SQLite - SQLite command line

Sqlite Banner

SQLite - SQLite command line

Start

The database file is test.db 

sqlite3 test.db

Command

  • .tables: list out all tables.
  • .schema: the schema of how the tables were created in the database
  • .header on: column name be printed out as well
  • .quit to exit.




Discover More
Sqlite Banner
SQLite - Case statement

The case statement in sqlite The value base format with the weekday name from its number (o being sunday). The conditional based format Example where Saturday and Sunday are marked as weekend...
Sqlite Banner
SQLite - Except (Minus)

in sqlite First table bag Except
Sqlite Banner
SQLite - Getting Started

A getting started guide Download the shell binary for windows By default SQLite client tool do not format the columns in a human read-way, so to explore table...
Sqlite Banner
SQLite - Index (indices)

in Internally, SQLite assumes that indices stored in database files are sorted according to the collation sequence indicated by the SQL schema. Changing the definition of a collation sequence after...
Sqlite Banner
Sqlite - Join

Join documentation for sqlite Reference Syntax documentation
Sqlite Banner
Sqlite - Upsert

This page is the upsert statement in Sqlite The Sqlite upsert syntax can be found at Upsert. This page shows you some This example shows statement based...



Share this page:
Follow us:
Task Runner