Monday, April 14
Pixy's Actually Useful Tip Of The Day
MySQL will automatically convert integer values into strings when needed.
Mostly.
When you are supplying an index key, it will do the conversion, and actually work, but the query analyzer won't recognise it and won't use the index. Even if you use a FORCE INDEX clause.
Yay for subtle but deadly behaviours.
Comments are disabled.
Post is locked.
MySQL will automatically convert integer values into strings when needed.
Mostly.
When you are supplying an index key, it will do the conversion, and actually work, but the query analyzer won't recognise it and won't use the index. Even if you use a FORCE INDEX clause.
Yay for subtle but deadly behaviours.
Posted by: Pixy Misa at
11:36 PM
| Comments (2)
| Add Comment
| Trackbacks (Suck)
Post contains 59 words, total size 1 kb.
45kb generated in CPU 0.02, elapsed 0.1483 seconds.
56 queries taking 0.1346 seconds, 328 records returned.
Powered by Minx 1.1.6c-pink.
56 queries taking 0.1346 seconds, 328 records returned.
Powered by Minx 1.1.6c-pink.