18.2.23 Don't rely on automatic type conversionThis is NOT the latest copy of this book; click here for the latest version.
This will only yield a tiny speed boost, but every little helps. If you declare a field as having an Age field of type INT, this query is in fact valid:
UPDATE table SET Age = "1"
The query states that Age should be set to the string value "1", not the number 1. However, MySQL will recognise that Age should be an integer, and automatically convert the string "1" to the integer 1 before updating the table. This type conversion is indeed very helpful, but, as we already knew that Age was going to be an integer, we could have saved MySQL some pointless work and not used the quotes.
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
