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