The Command to open a database file is:.Double click sqlite3.exe to open the SQLite command line.Navigate manually to the folder where sqlite3.exe is located “C:\sqlite”.If you want to learn how to open SQLite file and create the database file in a specific location rather than in the same location where the sqlite3.exe is located, here is how to view SQLite database: SQLite CREATE Database in a Specific Location using Open This will give you the list of databases created, and you should see the new database “ SchoolDB.db” listed there: You can ensure that the database is created by writing following SQLite commands:.If you select SQLite file and navigate to the directory: “c:\sqlite”, you will find the file “SchoolDB.db”is created as the following screen shot:.This will create a new database with the name “ SchoolDB.db”in the same directory where you have copied your.Following is the basic syntax of sqlite3 command to create a database. After that we should select SQLite file and navigate where the sqlite3.exe is located by the following SQLite command line:.From the Installation and packages tutorial, you should now have created an SQLite folder in the “C” directory and copied the sqlite3.exe on it.The “cmd” will open in the default user folder, on my machine, it is “C:\Users\MGA”:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |