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.<br><br><div class="gmail_quote">
On Tue, Jun 10, 2008 at 2:07 AM, Jason Flatt <<a href="mailto:drupal@oadaeh.net">drupal@oadaeh.net</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Mon Jun 9 2008 1:48:02 pm Steven Jones wrote:<br>
> If you care that much, you're probably looking at the table in<br>
> something like phpMyAdmin, in which case you can do this:<br>
> <a href="http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html</a><br>
><br>
> otherwise just query the columns in a different order as chx says.<br>
<br>
</div>No. What he said was that it doesn't matter what order the columns are in. He<br>
didn't say to query them in a different order. They can be queried in any<br>
order.<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
> On Mon, Jun 9, 2008 at 9:43 PM, Karoly Negyesi <<a href="mailto:karoly@negyesi.net">karoly@negyesi.net</a>> wrote:<br>
> >> Make sense?<br>
> ><br>
> > Nope. I try to refrain from being a maths egghead but SQL does not need<br>
> > or rely on column order.<br>
> ><br>
> > Regards<br>
> ><br>
> > NK<br>
<br>
<br>
--<br>
</div></div><font color="#888888">Jason Flatt<br>
<a href="http://www.oadaeh.net/" target="_blank">http://www.oadaeh.net/</a><br>
Father of Six: <a href="http://www.flattfamily.com/" target="_blank">http://www.flattfamily.com/</a> (Joseph, 15; Cramer, 13; Travis,<br>
11; Angela; Harry, 7; and William, 2)<br>
Linux User: <a href="http://www.kubuntu.org/" target="_blank">http://www.kubuntu.org/</a><br>
Drupal Fanatic: <a href="http://drupal.org/" target="_blank">http://drupal.org/</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Ashraf Amayreh<br><a href="http://blogs.aamayreh.org">http://blogs.aamayreh.org</a>