how does mysql handle NULLs in indexes
Posted on 2014-01-10
I'm a little unsure about how mysql handles nulls in indexes.
Can I have an index on a column that contains Nulls?
If I have an index based on a text field which can contain Nulls will mysql add the nulls to the index? Will they be added at the top or bottom if they are added (not that that matters 0 I'm just curious).