Re: how do I change an column

From: Manfred Fandel (mf@fandel.com)
Date: Thu Oct 21 1999 - 08:04:36 EST

Hi,

Ricker Muņoz wrote:
>
> hi list ..
>
> sorry my english is not good bad, can any one help me to change a data
> type of column an existing table.???
>
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

and should run fine !

Manfred 

-- 
Manfred Fandel          Telefon(Fax auf Anfrage):
Georgstr.14             02236-842403	
50389 Wesseling         EMAIL: fandel@fandel.com
PGP-key per "finger -l fandel@zeus.cs.uni-bonn.de"
-------------------------------------------------------------------------
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