How to install SQLite database on Windows 11 || Creating a database and table in SQLite 2023 updated

Hello friends welcome back to Google ID help in this session we are going to download and install sqlite on Windows 11. let's dig in first of all open your favorite browser and go to the search bar and type download sqlite press enter and you will see some results go to the first one and you can see this official download page of the sqlite here you can see we have so many links just scroll down we are looking for the pre-compiled binaries for Windows now you can see here we have this heading under this heading we have three different packages the first one is Windows 3286 dot zip 32-bit dll and sqlite version and the second one is Windows 64 x 6464 bit sqlite version and the third one is the sqlite tools when zip x86 you can see the description a bundle of the command line tools for managing sqlite databases files including the command line cell program and the SQL diff.exe program so we have other additional things with this package so we are going with that just click on it to download you can see download is done quickly and I will put this package here in the separate folder now the next task is unzip this file do the right click use the unzip utility and extract this file so this way you will get a folder now we will look inside this folder again we have this folder so because we extracted with the same name and this just created another folder so first I will rename the internal folder so I am giving a very short name like SQL 3 so this is quite easy to remember this name and when you go inside this folder you will find this three files now I will cut this and bring it to one label back so now we have the final folder which is sqlite 3 which we have renamed and placed it here now the next task is to set up the environment variable go to the search and now type involvement now you can see this option edit system variable click on it then you will see the system properties box click environment variables now you are at this place click on the path variable okay now what path we need to update so go inside this sqlite folder which we have just created and here we have all those files so we will copy the path and paste it here so we are maintaining A New Path entry here in this system variable save it and closed so we have done the environment variable setup successfully now it's time to verify is it working or not go to the search just type CMD okay this way we have CMD open now here we have to type simple command type sqlite3 press enter and then you will see this message sqlite version 3.4 2.0 and connected to the transient in-memory database that means you are connected to the database and now you are inside the sqlite shell now you can type the command dot help so you will see the list of all the available commands to interact and manage the sqlite database here in these commands you can see we have the many important commands like dot databases dot connection dot axial doll dot schema dot output and Dot quit if you want to exit from this shell you have to Simply type the command dot quick quit and press enter now let me show you if you type dot quit press enter you will exit from the shell now suppose you want to create a database inside a folder so just create any folder go inside that folder go to the address bar and type CMD and the CMD will open to create the database you have to type sqlite3 space database name dot DB press enter and then you will see this message and the sqlite cell will appear but when you see inside the folder there is no database by default this database is hidden to unhidden this database we need to type another command dot databases press enter and then you will see the database file inside the folder now you can interact with that that database now suppose you want to create one table inside this database now what we need to do we will write a query for that so this is the query create table table name bracket ID is the column that I want to create which is the integer and we want to set it as a primary key bracket close semicolon press enter and you will see that table is created now if we want to check this table is created or not or how many tables are there inside this database we need to Simply type dot tables press enter you will see the results all available table names here on the shell now again if you want to see this schema of the table so you have to specify the table name so the command will be dot schema space table name press enter and you will see the schema of that table and guys there are so many commands to interact and manage the escalite database and this is all about the downloading and installation and creating a simple database inside the sqlite on Windows 11. I hope you guys found this tutorial relevant and useful please hit the like button to appreciate and please subscribe to learn more and for now thanks for watching cool it help

Channel: Cool IT Help

Views: 36,342

Keywords: How To Install SQLite On Windows 11, How to Download & Install SQLite on Windows, sqlite download for windows 11 64-bit, how to download sqlite for windows 11, how to install sqlite3 on windows 11, how to download sqlite for windows 10, install sqlite3 windows, install sqlite3 linux, install sqlite3 python pip install sqlite3

Id: -bDwNR_C0dE

Length: 6min 54sec (414 seconds)

Published: Sat Jun 10 2023