Re: [sqlite] change sqlite table column type

2010-11-15 Thread Kees Nuyt
On Mon, 15 Nov 2010 14:56:47 + (UTC), Oliver Peters wrote: >Jay A. Kreibich writes: > >[...] >> >> You can also live dangerously and set "PRAGMA writable_schema=1", >> allowing you to UPDATE the sqlite_master table directly. >> >>-j >> > >is this

Re: [sqlite] change sqlite table column type

2010-11-15 Thread Jay A. Kreibich
On Mon, Nov 15, 2010 at 02:56:47PM +, Oliver Peters scratched on the wall: > Jay A. Kreibich writes: > > > You can also live dangerously and set "PRAGMA writable_schema=1", > > allowing you to UPDATE the sqlite_master table directly. > > is this PRAGMA documented? No, not

Re: [sqlite] change sqlite table column type

2010-11-15 Thread Oliver Peters
Jay A. Kreibich writes: [...] > > You can also live dangerously and set "PRAGMA writable_schema=1", > allowing you to UPDATE the sqlite_master table directly. > >-j > is this PRAGMA documented? Can't find it here http://www.sqlite.org/pragma.html What do I achieve by

Re: [sqlite] change sqlite table column type

2010-11-15 Thread Jay A. Kreibich
On Mon, Nov 15, 2010 at 08:34:22AM +, Oliver Peters scratched on the wall: > lizhe 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

Re: [sqlite] change sqlite table column type

2010-11-15 Thread Oliver Peters
lizhe 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 edit file.sql sqlite3 yournewdatabase <

Re: [sqlite] change sqlite table column type

2010-11-14 Thread Drake Wilson
Quoth lizhe , on 2010-11-15 10:59:40 +0800: > Dear Sir: > I have a table type is blob,I think update integer type, > How to solve my trouble? "alter" SQL? No. If you really need that you'll need to recreate the table. But manifest typing means you probably don't need

[sqlite] change sqlite table column type

2010-11-14 Thread lizhe
Dear Sir: I have a table type is blob,I think update integer type, How to solve my trouble? "alter" SQL? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users