SQLite Knowledge Base: Unterschied zwischen den Versionen

Aus MattWiki
(Die Seite wurde neu angelegt: „This article contains basic knowledge, commands and how to's for SQLite. SQLite is the most used database engine in the world. = General Information = Open database.sqlite with sqlite CLI client: sqlite database.sqlite Within SQLite CLI interface .help # Help .exit # Quit .tables # List all tables Kategorie:SQL“)
 
Keine Bearbeitungszusammenfassung
 
Zeile 7: Zeile 7:
  sqlite database.sqlite
  sqlite database.sqlite
Within SQLite CLI interface
Within SQLite CLI interface
.help                 # Help
{|
.exit                 # Quit
|+
.tables               # List all tables
!Command
!Description
|-
|<code>.help</code>
|Help
|-
|<code>.exit</code>
|Quit
|-
|<code>.tables</code>
|List tables in database
|-
|<code>.schema [<tablename>]</code>
|Show database table description, optionally for a given table name
|}
[[Kategorie:SQL]]
[[Kategorie:SQL]]

Aktuelle Version vom 6. April 2024, 20:33 Uhr

This article contains basic knowledge, commands and how to's for SQLite.

SQLite is the most used database engine in the world.

General Information

Open database.sqlite with sqlite CLI client:

sqlite database.sqlite

Within SQLite CLI interface

Command Description
.help Help
.exit Quit
.tables List tables in database
.schema [<tablename>] Show database table description, optionally for a given table name