Hi Dennis,
I followed your path and managed to rebuild my table. All is well in the land
of Roman now. Thanks again,
Roman
On Friday 07 April 2006 11:57 am, Dennis Cote wrote:
> Roman wrote:
> >http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
> >
> >says that such is not possible
>
Roman wrote:
http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
says that such is not possible
On Friday 07 April 2006 11:39 am, Roman wrote:
I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
I misspelled a column name, and I am curious if there is a command
Here's what I might do, I'd be curious of the other's answers.
You could use the .dump command, redirect it into a flat file
Use sed to fix the field name in the file.
Delete the old table.
Then load it back in using the corrected dump file.
-alex
On Apr 7, 2006, at 10:39 AM, Roman wrote:
I
Roman <[EMAIL PROTECTED]> writes:
> I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
>
> I misspelled a column name, and I am curious if there is a command to change
> the name from sqlite3 interface.
A bit simplistic, but:
echo ".dump" | \
sqlite3 database.db | \
sed
http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
says that such is not possible
On Friday 07 April 2006 11:39 am, Roman wrote:
> I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
>
> I misspelled a column name, and I am curious if there is a command to
> change the
5 matches
Mail list logo