[<<][sql][>>][..]
Fri Sep 12 18:56:37 CEST 2014

growing sqlite3

Changing the structure of a DB without rebuilding is new to me!
Some notes.  I really start to like SQL, but the syntax is hard to remember.

  DELETE FROM storage where host = 'zoo';


sqlite has a limited form of 'ALTER TABLE', however adding a column is
and setting a default supported:

  ALTER TABLE storage ADD mtime INTEGER;
  UPDATE storage SET mtime = 0;

I'm not sure if it's possible to change the key structure.



[Reply][About]
[<<][sql][>>][..]