SQLite : How to Install SQLite on Windows, Create Database, Table, Column

SQLite tutorials for beginner : how to install embedded database SQLite on windows, macos, linux, mozilla firefox or android? see SQLite tutorial on hc-kr.com

SQLite Tutorials for Beginner - How to install and make a database using embedded database SQLite on windows, mac os, linux, android or browser mozilla firefox, Chrome? This tutorial will try to explain in detail about the basics of the how to use and creation a databases, tables and columns using the Embedded Database with SQLite for step by step.

What is SQLite?


SQLite is an embedded database that is very famous for incorporating SQL interface with a very small memory and very good speed. SQLite is an open-source Embedded database that has been there long enough, it's quite stable, and is very popular on small devices.
SQLite : How to Install SQLite on Windows, Create Database, Table, Column

Support

SQLite can be used on Windows Phone, Android, iPhone, PHP, Firefox, Chrome and others with small projects. See more detailed at http://www.sqlite.org/famous.html. On the web browser, we can using SQLite to store a configuration as history, bookmarks, and the cache, while in the mobile, you can use SQLite for saving a contact numbers and more.

Licence

SQLite is Open Source (Free), so developers can use it for the purposes of the production application. To download and install them can follow my tutorial step by step.

Installation SQLite

Read : How to Install MySQL Database on Localhost windows

To install SQLite you must download it first, here i'll show you how to download SQLite databse required files, first go to http://sqlite.org/download.html and download download all rewuired files.

1. Download and Install SQLite on Windows

Required Files (Precompiled Binaries for Windows) :
  1. sqlite-dll-win32-x86-3130000.zip (422.71 KiB) for 32-bit
  2. sqlite-dll-win64-x64-3130000.zip (700.46 KiB) for 64-bit
  3. sqlite-tools-win32-x86-3130000.zip (1.51 MiB)

How to Install and crate a database with SQLite on windows?

Extract the files you've downloaded, and put in place on the disk c:, for example I will create a new folder and put all the files I've downloaded earlier in "c:\sqlite\"

Install SQLite on Windows

Create a Databases with SQLite

Just open your command prompt (CMD) windows and type "cd C:\sqlite", to crate a database just follow this command :
C:\sqlite>sqlite3 hc-kr.db
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
Change hc-kr.db with your databases name.

How to check Our databases?

sqlite> .databases
seq  name             file
---  ---------------  ----------------------------------------------------------
0    main             c:\sqlite\.databases

How to Dumb our Databases?

c:\sqlite>sqlite3 hc-kr.db .dump > hc-kr.sql

How To create table in SQLite?

sqlite> CREATE TABLE users(
   ...> id INT NOT NULL PRIMARY KEY,
   ...> name CHAR(50) NOT NULL,
   ...> password CHAR(50) NOT NULL,
   ...> level INT NOT NULL
   ...> );
sqlite>

How to View structurs of the table?

sqlite> .schema users
CREATE TABLE users(
id INT NOT NULL PRIMARY KEY,
name CHAR(50) NOT NULL,
password CHAR(50) NOT NULL,
level INT NOT NULL
);
sqlite>

How to Insert Data Into Table?

sqlite> INSERT INTO users VALUES ('1','Harison Matondang','123456789','1');
sqlite> INSERT INTO users VALUES ('2','Hc-Kr-Com','1234','2');

How to View data from Table?

sqlite> SELECT * FROM users;
1|Harison Matondang|123456789|1
2|Hc-Kr-Com|1234|2

or you can type command lind with more spesifications
sqlite> .header on
sqlite> .mode column
sqlite> SELECT * FROM users;
id          name               password    level
----------  -----------------  ----------  ----------
1           Harison Matondang  123456789   1
2           Hc-Kr-Com          1234        2

How to Delete table?

sqlite> DROP TABLE users;

Follow and subscribe For more tutorial about SQLite from us for free.

COMMENTS

Next Recomended


Feel free to code it up and send us a pull request.

Hi everyone, let's me know how much this lesson can help your work. Please Subscribe and Follow Our Social Media 'kodeajaib[dot]com' to get Latest tutorials and will be send to your email everyday for free!, Just hit a comment if you have confused. Nice to meet you and Happy coding :) all ^^



Follow by E-Mail


Name

ADO.NET,3,Ajax,6,Android,9,AngularJS,4,ASP.NET,4,Blogger Tutorials,7,Bootstrap,7,C++,1,Codeigniter,2,Cplusplus,6,Crystal Report,6,CSharp,25,Ebook Java,2,FlyExam,1,FSharp,3,Game Development,2,Java,35,JDBC,2,Laravel,84,Lumen,2,MariaDB,2,Ms Access,3,MySQL,31,ODBC,6,OleDB,1,PHP,14,PHP Framework,5,PHP MYSQLI,9,PHP OOP,5,Python,8,Python 3,4,SQL Server,4,SQLite,4,Uncategorized,5,Vb 6,2,Vb.Net,89,Video,48,Vue Js,4,WPF,2,Yii,3,
ltr
item
KODE AJAIB: SQLite : How to Install SQLite on Windows, Create Database, Table, Column
SQLite : How to Install SQLite on Windows, Create Database, Table, Column
SQLite tutorials for beginner : how to install embedded database SQLite on windows, macos, linux, mozilla firefox or android? see SQLite tutorial on hc-kr.com
https://2.bp.blogspot.com/-C3yZiCy2dXs/V0t1JVRlICI/AAAAAAAABzg/0No8g8lHSYw9WOVO6pQiwfWTgMEqpzZWgCLcB/s320/SQLite370.svg.png
https://2.bp.blogspot.com/-C3yZiCy2dXs/V0t1JVRlICI/AAAAAAAABzg/0No8g8lHSYw9WOVO6pQiwfWTgMEqpzZWgCLcB/s72-c/SQLite370.svg.png
KODE AJAIB
https://www.kodeajaib.com/2016/05/sqlite-how-to-install-sqlite-on-windows.html
https://www.kodeajaib.com/
https://www.kodeajaib.com/
https://www.kodeajaib.com/2016/05/sqlite-how-to-install-sqlite-on-windows.html
true
3214704946184383982
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy