Re: how do I change an column

From: Ing. Juan Carlos Fernandez-B (juan@linux.form-net.com)
Date: Thu Oct 21 1999 - 07:43:39 EST


Hola Ricker,
What I do is I dump the database (msqldump databasename tablename >
datafile.txt)
edit the file with your favorite editor to fit your needs and then drdrop
the old table.
$msql
drop tablename
\g
\q
and then upload the edited table with msql databasename < datafile.txt

saludos
Juan cArlos

On Wed, 20 Oct 1999, Ricker [iso-8859-1] 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.???
>
> -------------------------------------------------------------------------
> To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>

-------------------------------------------------------------------------
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