Re: Nu-B\Column:Alter type

Thanks for your support Josh...

In your sequence below - where does the column (e.g. col 8 of 25) get changed?

Would I list the good column names to insert into bad_table in point 4., then insert my new column - or is there a way to "select * except one" (I guess that's pretty lax SQL)?

Am I making sense?

/j-p.

On Fri, 22 Feb 2002, Josh Berkus wrote:

> John-paul,
>
> > How do I change a column from date type to text?
>
> This functionality is not supported in version 7.2 or earlier. You
> will have to drop and re-create the table:
>
> 1. CREATE TABLE temp1 AS
> SELECT * FROM bad_table;
> 2. DROP TABLE bad_table;
> 3. CREATE TABLE bad_table;
> 4. INSERT INTO bad_table SELECT * FROM temp1;
> 5. DROP TABLE temp1
>
> -Josh Berkus
>

-----------------------
JUSTATEST Art Online
www.justatest.com