Ben
Reputation: 6086
MySQL - index to support one or more values must not be NULL
Is it possible to create a MySQL index that drops records unless one of n fields is not null?
I know Multiple-Column Indexes exists but would this be possible?
Upvotes: 0
Views: 36
Answers (1)
Namphibian
Reputation: 12221
MySQL does not support filtered/conditional indexes. See this answer for more details: https://dba.stackexchange.com/questions/43/how-to-create-a-conditional-index-on-mysql
Upvotes: 1
Related Questions
- Mysql index on condition "field IS NULL"
- mysql - "column cannot be null"
- mysql index: possible_keys is null but key isn't null
- Can we create an index on a column containing NULL values in MySQL 5.7?
- mysql not to allow NULL on unique index
- MySQL cardinality of NULL values
- Add an index to see if a field is NULL
- Mysql index on values != 0
- mysql unique index EXCEPT empty or null
- index on column which is only used for IS NULL and IS NOT NULL