Small. Fast. Reliable.
Choose any three.

Page History

Turn Off History

There is a list of features that SQLite does not support at http://www.sqlite.org/omitted.html. If you find additional features that SQLite does not support, you may want to list them below.


  create table db1.table1 as select * from db2.table1;

  START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)

      SELECT x.Hours median
      FROM BulbLife x, BulbLife y
      GROUP BY x.Hours
      HAVING 
         SUM(CASE WHEN y.Hours <= x.Hours 
            THEN 1 ELSE 0 END)>=(COUNT(*)+1)/2 AND
         SUM(CASE WHEN y.Hours >= x.Hours 
            THEN 1 ELSE 0 END)>=(COUNT(*)/2)+1

  sqlite info.db
  .mode insert
  SELECT version, date, name, summary FROM logs;

(Hey, the formatting of this page was screwed up, let's see if it's better now...)