MySQL Forums
Forum List  »  Spanish

Advanced Search
New Topic

Re: problema con: order by 'id'
Posted by: William Chiquito
Date: January 31, 2008 07:15PM

Hola Carlos,

No he usado versiones anteriores a la 5.x de MySQL, sin embargo, en la documentación (8.2. Database, Table, Index, Column, and Alias Names) se indica que el identificador que debe usarse es el backtick (“`”). La comilla simple (“'”) indicaría que es un líteral por lo que deseas ordenar en tu consulta.

Pienso que en todo caso sería un error (bug) de la versión de MySQL que usabas (3.23.58).

Existía un error (bug) semejante con el "GROUP BY" en versiones anteriores, mira en Bug #14019: group by converts literal string to column name.



Edited 2 time(s). Last edit at 01/31/2008 07:16PM by William Chiquito.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
problema con: order by 'id'
4462
Carlos Hernandez
January 31, 2008 10:06AM
Re: problema con: order by 'id'
2102
William Chiquito
January 31, 2008 07:15PM
Re: problema con: order by 'id'
2225
Carlos Hernandez
February 01, 2008 05:13AM
Re: problema con: order by 'id'
2737
Miguel Perez
February 04, 2008 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.