changing sort order of fields in MySQL
| From: | Irfan Uygur | Date: | Fri, 13 Oct 2000 07:34:06 +0000 |
| Subject: | changing sort order of fields in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3575@lists.php.net to get a copy of this message | ||
I know this sounds stupid, but i'm currently designing a MySQL dbase that's
going to work mith my PHP code, and as the program
gets more and more complex, i have to add new fields to MySQL. I'm using
MyAdmin in order to speed up the db stuff and while listing the fields
MyAdmin sorts the fields' creation date. For ex if i have name,sex,
location, tel, fax fields and then if a later add a field "age"
it lists the fields as name,sex, location, tel, fax , age but it would be
more easier for me to follow-up if listed the fields as
name, sex, age, location, tel, fax. So is there a way to change the order of
appearance of fields ?
I looked up the MySQL ref but couldn't find any relevant info about this.
Thanks in advance.
Irfan Uygur