I guess that as long as I could insert in any order I want there shouldn't be a problem, although having some users with a table that has columns with a different order than others seems a little awkward. On Tue, Jun 10, 2008 at 2:07 AM, Jason Flatt <drupal@oadaeh.net> wrote:
On Mon Jun 9 2008 1:48:02 pm Steven Jones wrote:
If you care that much, you're probably looking at the table in something like phpMyAdmin, in which case you can do this: http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html
otherwise just query the columns in a different order as chx says.
No. What he said was that it doesn't matter what order the columns are in. He didn't say to query them in a different order. They can be queried in any order.
On Mon, Jun 9, 2008 at 9:43 PM, Karoly Negyesi <karoly@negyesi.net> wrote:
Make sense?
Nope. I try to refrain from being a maths egghead but SQL does not need or rely on column order.
Regards
NK
-- Jason Flatt http://www.oadaeh.net/ Father of Six: http://www.flattfamily.com/ (Joseph, 15; Cramer, 13; Travis, 11; Angela; Harry, 7; and William, 2) Linux User: http://www.kubuntu.org/ Drupal Fanatic: http://drupal.org/
-- Ashraf Amayreh http://blogs.aamayreh.org