SQLite - CREATE Database

In SQLite the sqlite3 command can be used to create a database.

Basic Syntex

The syntex fro creatin a new database using SQLite is show below:

$sqlite3 your_database_name.db

To create a new database in SQLite follow the steps below:

Go to command prompt
type cd \ (press enter)
cd sqlite (press enter)
sqlite3 mydb.db(press enter)
.databases(press enter)

On the terminal the output will be displayed as shown below:

$sqlite3 mydb.db
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
sqlite>

The above command will create a database named mydb.db in your present working folder.

After the database is created sqlite3 command will give a sqlite>.

.databases Command

Once the database is created .databases command can be used to list the databases.

sqlite> .databases
seq  name             file             
---  ---------------  --------------------------------------
0    main             /home/sqlite/mydb.db        
sqlite>

.quit Command

.quit command can be used to quit the sqlite interface.

sqlite> .quit
$

SqLite Tutorial

SqLite - HOME SqLite - Intro SqLite - Installation SqLite - Syntax SqLite - Data Types SqLite - Create DB SqLite - Create Table SqLite - Drop Table SqLite - Select SqLite - Distinct SqLite - Where SqLite - And & Or SqLite - Order By SqLite - Insert Into SqLite - Update SqLite - Delete SqLite - Injection SqLite - Select Top SqLite - Like SqLite - Wildcards SqLite - In SqLite - Between SqLite - Aliases SqLite - Joins SqLite - Inner Join SqLite - Left Join SqLite - Right Join SqLite - Full Join SqLite - Union SqLite - Select Into SqLite - Insert Into Select SqLite - Constraints SqLite - Not Null SqLite - Unique SqLite - Primary Key SqLite - Foreign Key SqLite - Check SqLite - Default SqLite - Create Index SqLite - Drop SqLite - Alter SqLite - Auto Increment SqLite - Views SqLite - Dates SqLite - Null Values SqLite - Null Functions SqLite - Data Types SqLite - DB Data Types

SqLite Functions

SqLite - Functions SqLite - Avg() SqLite - Count() SqLite - First() SqLite - Last() SqLite - Max() SqLite - Min() SqLite - Sum() SqLite - Group By SqLite - Having SqLite - Ucase() SqLite - Lcase() SqLite - Mid() SqLite - Len() SqLite - Round() SqLite - Now() SqLite - Format()