menu close
Logos / APISuite / White / Symbol
Combined Shape
Hackfridays
Combined Shape
Savvy
Logos / Cloudoki / Outline / Icon
Cloudoki
Combined Shape
  • Home
  • Jobs
  • Team
  • Use-cases
  • Tech
  • Culture
  • Contact
Path linkedin instagram twitter Group
We are hiring!

SQL

— A collection of 1 post

SQL

A Simple Autistic SQL trick

Ever had that sickening feeling that after a Database efficiency cleanup, your ID's are no longer in line with the actual amount of records? Congratulations, you have autistic tendencies! (We have a club) Set @a = 0; update tablename set id=@a:=@a+1 order

  • Koen Betsens
    Koen Betsens
Koen Betsens 19 Jul 2015 • 1 min read
Discover more logos/mono/cloudoki logos/mono/apisuite logos/mono/savvy logos/mono/hackfridays logos/mono/tricryo logos/mono/donderlab
Cloudoki © 2021