So apparently in MySQL, 0 doesn’t always equal 0, sometimes it can be 1, or 2, or 3...

what the actual fuck?!?!

  • 1
    Can you elaborate?
  • 5
  • 0
    I was building a query earlier based on a rating system and I was looking any zero ratings by doing “rating = 0” and rather oddly, it returns scores of 7.8 and 9.2 which really baffled me
  • 3
    @err-occured I cant say I've ever experienced that in the best part of 15 years 🧐

    What table engine are you using, I want to experiment also is it decimals or floats for the data type?
  • 2
    I’ve been using MySQL for about 9 years and I was very confused, it broke my brain for a couple of minutes
Your Job Suck?
Get a Better Job
Add Comment