MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Mysql Create index on integer column with specific length not working
Posted by: Rick James
Date: September 30, 2013 07:49PM

The 5 (in EXPLAIN) comes from 4+1 -- 4 for the size of INT plus 1 for room for NULL.

ALTER TABLE foo MODIFY COLUMN bar INT NOT NULL;
(be sure to replicate any other specifications of `bar` when ALTERing.)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Mysql Create index on integer column with specific length not working
sandeep thakur
September 30, 2013 05:48AM
Re: Mysql Create index on integer column with specific length not working
Peter Brawley
September 30, 2013 12:01PM
Re: Mysql Create index on integer column with specific length not working
Rick James
September 30, 2013 07:49PM
Re: Mysql Create index on integer column with specific length not working
sandeep thakur
October 02, 2013 11:55PM


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.