Re: Reordering columns in a table

John McCawley <nospam(at)hardgeus(dot)com> schrieb:

> I believe that it makes a lot of practical difference, just like organizing
> related code into files, classes etc. is important for clarity. This isn't
> a trivial thing, and the other (sarcastic?) suggestion that I reorder my
> select misses the point.

Not really sarcastic. You can't expect the order of values in a table,
and you can't expect the order of columns in a table.

If you do a 'select * from ...', and the table-structure is changed,
then you get problems. If you do a 'select col1, col2, col2, ... coln
...'), no problems.

A (german) article about this (with mysql):
http://php-faq.de/q/q-sql-select.html

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°