Results 1 to 2 of 2
May 27, 2004, 02:16 #1
- Join Date
- May 2003
- Kuala Lumpur, Malaysia (Boleh!)
- 0 Post(s)
- 0 Thread(s)
Mysql: Change the sequence of the db field for readability purpose
When we go to database structure, we see those db field row by row, isn't? I wonder if there is any way for me to change the sequence of my database field. The purpose for me to change the sequence is for readability purpose.
May 27, 2004, 03:30 #2
create a new table with the desired sequence of columns and then copy the old data into the new table. You may use CREATE TABLE ... SELECT to do that in one step.Never ascribe to malice,
that which can be explained by incompetence.
Your code should not look unmaintainable, just be that way.