/    /  SQLiteDB – Create DB

SQLiteDB – Create DB:

In SQLite, the below command allows us to create the SQLite database

Syntax: sqlite3 database_name.db

Example:

[root@tuto~]# sqlite3 custDB.db

SQLite version 3.3.6

Enter ".help" for instructions

sqlite>

Verify the database that created with the below command.

sqlite>.databases

seq  name             file                                                     

---  ---------------  ----------------------------------------------------------

0    main             /root/custDB.db

sqlite>

To exit from the SQLite prompt, you need to give the below quit command.

sqlite>.quit