How to download install and configure SQLite 3 on Windows 10/11 | Install SQLite 3 on Windows | 2024

hello guys in this video we will see how to install and configure SQL light 3 on Windows 11 operating system the process is same for all Windows operating systems go to SQL light official website that is SQL it e.org see here sqlite is a c language library that implements small fast selfcontain High lity full featured SQL database engine sqlite is most used database engine in the world SQL it is built into all mobile phones and most computers and comes bundle inside countless other applications that people use every day see the latest release is this is the latest relas so click on download or just go to this download tab go scroll down see here we have the pre-compiled binaries for Windows So based on your operating system you have to select 32bit DL or 64 M is 64bit so don't select these two select only this SQL see we have to download this a bundle of command line tools for managing SQL light database files including command line shell program and other tools okay so download this SQL Tools in x64 G file click on it see download has been started and it is complete go to downloads just click on it full download history go to download directory right click on it extract all you don't have wi 7 or any open source software download and install it okay extract all select the path I'm going with the current directory extract see files are extracted go to see here we have SQL 3.exe file okay so go to downloads copy this path go to C drive paste it rename it to SQL light 3 and hit enter now we have to set the environment variables without setting environment variable also we can Conn to sql3 but every time we have to come to this path and you have to click on this SQL 3. file so it is recommended or good practice to set up the environment variable for this sql3 okay copy this path right click on the this m or your mission name go to properties then Advanced system settings then environment variables then in system variables select the path then click on edit then click on new then paste this path that is this one okay then click on Okay click on Okay click on okay the other way to open environment variables is start then search for environment see here we have the edit the system environment variables click on it then click on environment variables go to system variables then select the path click on edit see at the end we have already if we don't have just click on new then paste it okay cancel cancel because I have already set CL this one also now open command pront CMD then see simply we can connect SQL hit enter see we have connected to sql3 and it vers is 3.4 45.1 and see here connected to transient in memory database because we haven't connected to any database let me verify the database see we don't have any database see here in quotations null nothing is there means you haven't connected to any database okay so let me close this one to quit we have to give the dot Q we have exited from the sql3 so to connect to database it is recommended the following practice okay go to C drive let me create a directory new folder then give the SQL light 3 DBS and hit enter go to this path copy this path CD enter now SQL light three suppose if I want to create database AOS SCH you this like a.tv and hit enter see before we got like connected to a transient in memory database but here we haven't that because we have connected to this AOS course database let me verify again do databases hit enter see this is the database name here also we have received or we created a file with the name after schools. let me create a table in this database before that verify the list of the tables do tables see we don't have any tables we want to get the help just give do help see these are the commands that we can run see these are the SQL light three options as I told you we have seen three examples of this one one is dot tables and Q where it yeah QR quit it is used to stop the interpreting input stream exit if primary okay another one is databases here it is C database okay so let me create a table in this database create table student then provide the column name data type S number int primary King s name where care I'm giving 50 put the semicolon at the end of the statement and hit enter it has created a table let me verify do tables see we have one table let me create another table create table staff St ID S ID in primary key staff name s name same 50 put semicolon and after every SQL statement and hit enter cany tables see you have two tables now insert some data into this table then we will see insert into table name is student values 100 because student number is of the data type integer so I have given 100 JS because I have given codes because it is type of character so I have given the enter is inserted use up Arrow now if you try with the same Arrow command it will throw error because the student number we defined as primary key let me try see we got the runtime error in constant failed so we have to give different one we give one not one it will take hit enter it is Success let me verify the list of the values in this table select start from student see we have two Row in this one the same way we can insert data in this staff table also okay again if you want to create one more database quit from this one just give do quit or Q both are same see we left from the SQL sh CLS to clear the screen as I told you to create another database give sql3 then HR is the database name. DV and hit enter see we have connected to H Let me refresh here still it is not showing why because go to dot databases see one is there see when we enter this do databases it has created a database but it size is zero even if you exit do quit still it will be there see it is not going to change if you want to connect to the same after schools and verify the data give it do tables see we have two tables again ify the data so let start from student put semicolon at the end of the statement see we have the data and one more I want to show you if you want to see the definition of this student table see we have created a table by using this syntax okay so in this video we have seen how to download install and configure SQL light 3 on Windows 11 operating system for more SQL light 3 videos please subscribe my channel thank you

Channel: r2schools

Views: 784

Keywords: Install SQLite 3 in Windows, Install SQLite 3 on Windows 10, Install SQLite 3 in Windows 11, Download and install SQLite 3 on Windows, Download SQLite for Windows, Download SQLite 3 for Windows, SQLite 3 Installation guide, SQLite Installation guide, SQLite 3 Installguide for Windows, SQLite installation tutorial, SQLite Install tutorial, SQLite Tutorials, SQLite Tutorials for beginners, Install and configure SQLite on Windows, Install SQLite on Windows Server, SQLite3 install

Id: AKynuCZttBs

Length: 10min 44sec (644 seconds)

Published: Fri Feb 16 2024