GILXA1226
Premium,MVM
join:2000-12-29
London, OH
clubs:
| reply to dk1983
Re: Mysql Descending / Ascending order
said by dk1983  :WOW well Ill be!!!  You can use numbers for the column to sort by?? The things you learn just by asking  Thank you Pete Yes, you can use numbers, however it's always better to use the actual column names. One good reason is, it makes the query easier to read, the other good reason is that is lessens the chance of the query breaking if in a week, month, year, you add another column into the select statement that changes what the number(s) is/are of the column(s) you were sorting by.
just my $0.02. |
|
PetePuma
How many lumps do you want
Premium,MVM
join:2002-06-13
Arlington, VA
| said by GILXA1226 :Yes, you can use numbers, however it's always better to use the actual column names. One good reason is, it makes the query easier to read, the other good reason is that is lessens the chance of the query breaking if in a week, month, year, you add another column into the select statement that changes what the number(s) is/are of the column(s) you were sorting by. just my $0.02. Agreed. Generally, I avoid the numeric syntax except with odd computed columns. |
|
GILXA1226
Premium,MVM
join:2000-12-29
London, OH
clubs:
| said by PetePuma :Agreed. Generally, I avoid the numeric syntax except with odd computed columns. You really shouldn't have to do it then, unless whatever database you are using doesn't support column aliasing. |
|
