Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
I had this yesterday but then differently. Selected something AS desc. Took me about half an hour to find out :/
-
vringar16198y@marceliwac iirc desc(ending) and asc(ending) are parameters in a query to describe how the output should be sorted. But my SQL is 4 or 5 years old by now so don't trust me.
-
@marceliwac used to order the output of the query. For example, select * from table order by id desc - would order the result set with ids starting at the largest and descending. The error is caused here because attempting to select the desc column will result in the SQL parser resolving it as an order instead of a column name, which throws errors. Select desc from table would fail, where select `desc` from table would succeed.
Related Rants
-
rephiscorth38Everyone here ranting about a fucking missing semicolon. I can't remember the last time a missing semicolon wa...
-
CodesNotHot11-Laughed at Gitlab the other day -Accidentally dropped my db today. fuck karma
-
codeclod15When you have a super annoying problem that Google has been unable to help with... But you stumble upon a link...
Never mind to my last rant. I FUCKING ACCIDENTALLY FUCKING NAMED A MYSQL FUCKING GOD FUCKING DAMN FIELD FUCKING DESC FUCK FUCK FUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUCKKKKKKKK FUCK fuck FUCK
undefined
fuck
accidental
accidental fuck
mysql desc