> only way:
>
> msqldump DB THISTABLE > TMPFILE.SQL
>
> then edit the data type of the colomn in TMPFILE.SQL by the create
> statement,
> and insert
> drop table THISTABLE \g
> in the first line of TMPFILE.SQL
> at last, do a
>
> msql DB < TMPFILE.SQL
I do the same except I make mistakes sometimes, so I redirect the output
to a file so I can study it and make sure it all went OK and no errors.
msql DB < TMPFILE.SQL > temp.txt
Good luck....
brew
==========================================================================
Strange Brew (brew@theMode.com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST