Gossamer Forum
Home : Products : Others : MySQLMan :

Field Order

Quote Reply
Field Order
Hi,
Can anyone tell me if it is possible to change the order of the fields once a table is created??
I have added some fields to my table and they are at the end of the properties list. I would like them to appear higher up in the properties list.
Any advise would be most appreciated.
Simon.

Quote Reply
Re: Field Order In reply to
I think that this is a limitation with MySQL...not with MySQLMan...remember that MySQLMan is only an emulerator to access MySQL databases and run functions...I would recommend searching through the MySQL documents at http://www.mysql.com...but I don't believe this is possible...

May be Alex or other GT staff can expound on this issue, but I don't think it is possible.

Regards,

Eliot Lee
Quote Reply
Re: Field Order In reply to
Hi,

Your best bet is to SQL Dump your database making sure you have extended insert selected. Then edit the file and change the order in the CREATE TABLE statement. Then run the file and it will be updated.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Field Order In reply to
Thanks for your reply.
I'm not exactly sure what you mean.
I have done the dump, created the file and changed the field order but I am not sure how to load it all back again.
Please explain a little more about the CREATE TABLE statement and how to run the file.
Thank you.
Simon.


Quote Reply
Re: Field Order In reply to
Alex,
I know your busy but I need to know how to reload my table.
If anyone else out there knows, please help me.
Thank you.
Simon.

Quote Reply
Re: Field Order In reply to
Hi,

To load it back in again, just click on SQL monitor, and then run queries from file.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Field Order In reply to
Hi,
So easy when you know what you are doing!!
Thanks Alex.
Not only did I learn how to change the field order but I also realized that I can build or modify all my tables offline instead of going through the slow process online via my browser.
Thanks again.
Simon.

Quote Reply
Re: Field Order In reply to
Hi Alex,

I tried it also this way and got this error:

MySQL said: Table 'CatLinks' already exists.

Query: CREATE TABLE CatLinks ( LinkID int(10) unsigned DEFAULT '0' NOT NULL , CategoryID int(10) unsigned DEFAULT '0' NOT NULL , KEY catlnndx (CategoryID), KEY lndx (LinkID) );

What´s to do?

Michael

Quote Reply
Re: Field Order In reply to
DROP the CatLinks table before re-creating it.

Regards,

Eliot Lee