On Mon, Nov 15, 2010 at 08:34:22AM +0000, Oliver Peters scratched on the wall: > lizhe <l...@...> writes: > > > > > > > Dear Sir: > > I have a table type is blob,I think update integer type, > > How to solve my trouble? "alter" SQL? > > [...] > > use the CLI (sqlite3) and your favourite editor: > > sqlite3 yourdatabase > .output file.sql > .dump > .q
You can also live dangerously and set "PRAGMA writable_schema=1", allowing you to UPDATE the sqlite_master table directly. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users