Is there any reason to worry about the column order in a table?

Asked 2009-05-21T18:59:36.067

I know you can ALTER the column order in MySQL with FIRST and AFTER, but why would you want to bother? Since good queries explicitly name columns when inserting data, is there really any reason to care what order your columns are in in the table?

mysql sql database-table

Edit Report

1 Answer

Readability of the output when you have to type:

select * from <table>

in your database management software?

It's a very spurious reason, but at the moment I can't think of anything else.

answered 2009-05-21T19:02:39.833

Is there any reason to worry about the column order in a table?

1 Answer

Your Answer