Using quotes for an numeric field
Hello,
Lets say my table has a single field int x.
when I perform select * from table where x = 100 and select * from table where x = '100'... does the second query be slower than the first one ?
Is there anyway to know to know how mysql interprets the query.. apart from explain statement ? rather for this specific case
Edited 1 time(s). Last edit at 08/17/2009 05:00AM by Abhilash L L.
Subject
Written By
Posted
Using quotes for an numeric field
August 17, 2009 04:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.