To install Sqlite3 in Ubuntu / Linux Mint issue the following commands
This will work for Ubuntu 14.04 and above
sudo apt-get update sudo apt-get install sqlite3 libsqlite3-dev
Basic Command Line Usage:
1. Create a new Database
aman@vostro:~$ sqlite3 databasename.db SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite>
2. Create a table and insert values in it.
sqlite> CREATE TABLE student (id integer, firstname varchar(30), lastname varchar(20), country varchar(20)); sqlite> INSERT INTO STUDENT VALUES (1, "James", "Hetfield", "USA"); sqlite> INSERT INTO STUDENT VALUES (2, "Kirk", "Hammet", "USA");
3. View all table entries
sqlite> select * from student; 1|James|Hetfield|USA 2|Kirk|Hammet|USA
4. Exit Sqlite3
sqlite> .exit
5. Open Existing Database
aman@vostro:~$ sqlite3 databasename.db
Tweet
No comments:
Post a Comment