When creating index for a column creates a new table for indexes
It is not a table.
Search for 'where column = null'.
For this condition no need any index or even data. By definition, an empty sample on the stage of the parser.
When talking about where column is null - it happens in principle, is called the partial index (partial index). But mysql is still not able.