In MySQL, should I quote numbers or not?

by

MySQL is a lot like PHP, and will auto-convert data types as best it can. Since you’re working with an int field (left-hand side), it’ll try to transparently convert the right-hand-side of the argument into an int as well, so '9' just becomes 9.

Strictly speaking, the quotes are unnecessary, and force MySQL to do a typecasting/conversion, so it wastes a bit of CPU time. In practice, unless you’re running a Google-sized operation, such conversion overhead is going to be microscopically small.

More Related Contents:

  1. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  2. What does SQL Select symbol || mean?
  3. i have an error which i dont understand. can you help me? [closed]
  4. In SQL Server how to get the count of child if both parent and child are available [closed]
  5. Delete the entire content of all table in a Database [closed]
  6. Rank function in MySQL
  7. MySQL select 10 random rows from 600K rows fast
  8. Get a list of dates between two dates
  9. Calculate a running total in MySQL
  10. Find nearest latitude/longitude with an SQL query
  11. Simulate lag function in MySQL
  12. Get record counts for all tables in MySQL database
  13. How do I check if a column is empty or null in MySQL?
  14. Use MySQL spatial extensions to select points inside circle
  15. INSERT … ON DUPLICATE KEY (do nothing)
  16. Subqueries with EXISTS vs IN – MySQL
  17. What is this operator in MySQL?
  18. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  19. MySQL Workbench: How to keep the connection alive
  20. Can I reuse a calculated field in a SELECT query?
  21. Deleting duplicate rows from a table
  22. SQL Group By with an Order By
  23. How create json format with group-concat mysql?
  24. MySQL INSERT INTO … VALUES and SELECT
  25. MySQL LIKE query with underscore
  26. Compare only day and month with date field in mysql
  27. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  28. What is the difference between SQL and MySQL? [closed]
  29. how to use a like with a join in sql?
  30. ORDER BY alphabet first then follow by number

Leave a Comment