create and use a sqlite database [ubuntu,debian]

install sqllite browser:
sudo apt-get install -y sqlitebrowser

create a new database:
open it and click on “New Database”
name it for example company.sqlite3 (name and ending does not matter)
click on “OK”

create a table with fields:
table "company"
click “add field”
Name:"name"
Type:"TEXT"

click “add field”
Name:"age"
Type:"INTEGER"

click “add field”
Name:"address"
Type:"TEXT"

click “OK”
sqllite-create-table

add entrys to the database:
click on “Browse Data”
click on “New Record”
doubleclick the fields and add the entrys

sqllite-add-data

click on “Write Changes”

to open it click on File->Open Database
choose “company.sqlite3”
and click “Open”

export as sql file:
File->Export->Database to sql file
File name:”company.sql”
click on “Save”

to import the exported company.sql:
File->Import->Database from SQL file
choose “company.sql”
click “Open”

choose a filename to save under
File name:”importSQL”
click “Save”

other sqlite tools:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s