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
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
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
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
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 <
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
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
7 matches
Mail list logo