SQLite :: How to create Database?
SQLite
How to create Database?How to Get All Database Name?
“ Main “ is
How to Create New Database Name?
Database name same as “Main “but location of database storage we can store different name
Like “Testdb. db ”
exe located
My Exe located in C:\Sqlite.exe
. db
Example Screen below
Like “Testdb
Step 1:
Go to RunStep 2:
Type CMDStep 3:
Sync location. WhereMy Exe located in C:\Sqlite.exe
Step 4:
C:\>sqlite3.exe SampleExample Screen below
.db file store location ? Is it store C:\Sample.db?
No
C:\Users\<YourName>\AppData\Local\VirtualStore\sample.db
How to modify above location?
computer
Sqlite window execute below query
C:\>sqlite3.exe Sample. db
No
C:\Users\<YourName>\AppData\Local\VirtualStore\sample.db
How to modify above location?
Step 1:
Go to MyStep 2:
Right Click èPropertyStep 3:
Advanced System SettingsStep 4:
Environment variablesStep 5:
Note:
Whenever open NewC:\>sqlite3.exe Sample
0 Comments