changing sort order of fields in MySQL

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

« previous php.db (#3575) next »