Increase id in SQL request



  • Hey, everybody, I have such a request:

    SELECT URL FROM t_links ORDER BY ID = ID + 1 DESC
    

    Now, this request is made when the timer works, every time the timer turns into a timer, the ID has to increase by one, but it's only happening once: Tell me how to fix the mistake. ♪ ♪



  • ORDER BY serves to indicate the sorting rather than to change the value. If you need to change the table, use the UPDATE operator.

    It's weird that the request doesn't cause a syntaxis error. I wonder what this is like.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2