Shantanu's Blog

// download and unzip the world database from
// http://saraswaticlasses.net/download/sql/lite.zip
// Start - Run... - command
// Change directory to the one where sqlite3.exe can be found
// start lite with world6 database in use
sqlite3.exe world6

// Show all tables
.tables

// select everything from City table and save it as CSV file
.mode csv
.output mycsv.csv
select * from City;

// change the output mode to screen
// else the output of select statements will be saved in the same csv file
// show the resuts on to the sceen
.output stdout

// create a table city2 based on City and import from CSV file
create table City2 as select * from City;
.import mycsv.csv City2

// select everything from CountryLanguage table and save it as html file
// Tip: you may need to add the table border = 1 and /table tags
.mode html
.output myfile.html
select * from CountryLanguage;

// backup table using sql statements
.output myfile.sql
.dump City

// backup selective records in sql format instead of entire table
.output myfile.sql
.mode insert
select * from City limit 10;

// recreate table City from the SQL statements source
// tip: you may need to delete the begin transaction and commit lines from the source
drop table City
.read myfile.sql

// import csv data into an existing table
.separator ,
.import myexcel.csv test

// show the resuts on to the sceen
.output stdout

// ask for help
.help

Labels: sqlite