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