sqlite3 basics in Windows command line
How to use sqlite3 in Windows command line to create a new database, execute sql commands from file, view database structure and other basics.
.open FILEPATH
.read FILEPATH
.shell cls
.mode column
.tables
.schema TABLE
PRAGMA table_info(TABLE);
last_insert_rowid();
.exit
.database
.shell cd
systempropertiesadvanced
#sqlite