MySQL Forums
Forum List  »  General

Re: search criteria - int datatype
Posted by: Rick James
Date: December 20, 2012 03:06PM

Using EXPLAIN is likely to answer the question better than I can.
EXPLAIN SELECT * table1 set col1 = '12' where col2 = 13 -- (and the other variation).

Also provide SHOW CREATE TABLE table1 .

Options: ReplyQuote


Subject
Written By
Posted
December 11, 2012 05:47PM
Re: search criteria - int datatype
December 20, 2012 03:06PM


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.