Installation begin from download zip file. So go to website: https://www.sqlite.org/ and click
Download in menu.
In download site find
Precompiled Binaries for Windows section. Download sqlite-tools ( sqlite-tools-win32-x86-3130000.zip ) file. Unzipp it in any place on your computer. Inside You see 3 files:
sqldiff, sqlite3 and sqlite3_analyzer.
SQLite You may run through double-click on the
In this moment command-line sqlite window appear.
If you would like create persistent database You must write
.open name_db ,
name-db notes your any name of database.
It is example for creating database of new name:
You see new.db file in given folder.
If You would like to create transient in memory database it will be sufficient to write queries in cosole without give any name of database. This database will be delete after close command line of sqlite.
create table tab(id int); insert into tab values(23); insert into tab values(45); select * from tab;
the content of this databse will be save in default folder:
SQLite database You may create opening windows command line. You go to folder of SQLite and create database:
Working with databse you end command:
After exit database, if You would like to connect another time, write only name of existing database, in windows command line it will be: