Re: change field types from several tables

02/01/2008, 00h16

Hi,

On Jan 1, 2008 6:22 PM, Miguel Vaz <dante@mail.telepac.pt> wrote:
>
> Hi,
>
> I am trying to import a big database of around 140 tables from xls
> to mysql. It works fine using navicat mysql, but i am running into a problem:
>
> Navicat tries to predict the field types, but makes a mistake on
> long text fields whose type needs to be "text", instead it makes them
> varchar(255), which is not enough for the content.
>
> I can solve the issue if i manually choose all field types to be
> "text", but since mysql has the alter table command to change field
> type, i was wondering if there is a way to change all fields from all
> tables to "text" automatically. This way i could import the table
> structure first, change all fields to type "text" and import tha data
> afterwards (the import is for an intermediary process, so no worries
> on all fields being "text" at this point).
>
> Something like:
>
> ALTER TABLE * CHANGE * * TEXT
>
> But obviously this doesnt work.
>
> Is this even possible using MYSQL? I could do it programmatically
> using PHP, i guess, but a single command would be far better. :-)

It's not possible.

02/01/2008, 00h16	#1
Baron Schwartz Messages: n/a Hébergeur:	Re: change field types from several tables Hi, On Jan 1, 2008 6:22 PM, Miguel Vaz <dante@mail.telepac.pt> wrote: > > Hi, > > I am trying to import a big database of around 140 tables from xls > to mysql. It works fine using navicat mysql, but i am running into a problem: > > Navicat tries to predict the field types, but makes a mistake on > long text fields whose type needs to be "text", instead it makes them > varchar(255), which is not enough for the content. > > I can solve the issue if i manually choose all field types to be > "text", but since mysql has the alter table command to change field > type, i was wondering if there is a way to change all fields from all > tables to "text" automatically. This way i could import the table > structure first, change all fields to type "text" and import tha data > afterwards (the import is for an intermediary process, so no worries > on all fields being "text" at this point). > > Something like: > > ALTER TABLE * CHANGE * * TEXT > > But obviously this doesnt work. > > Is this even possible using MYSQL? I could do it programmatically > using PHP, i guess, but a single command would be far better. :-) It's not possible.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email