Quick SQLite primer

The following sample SQL statements could help you navigate through the SQLite databases quickly:

//Set the column headers to show in the tool sqlite>.headers on

//select all rows from a table select * from table1;

//count the number of rows in a table select count(*) from table1;

//select a specific set of columns select col1, col2 from table1;

//Select distinct values in a column select distinct col1 from table1;

//counting the distinct values select count(col1) from (select distinct col1 from table1); //group by select count(*), col1 from table1 group by col1;

//regular inner join select * from table1 t1, table2 t2

where t1.col1 = t2.col1;

//left outer join

//Give me everything in t1 even though there are no rows in t2 select * from table t1 left outer join table2 t2 on t1.col1 = t2.col1 where

0 0

Post a comment