Peng Yu Unique on non null entries but allowing multiple nulls
Oct 17, 2011; 08:39
Peng Yu
Unique on non null entries but allowing multiple nulls
Hi,
If I use "NULL UNIQUE" when I create a table, it seems that only one NULL entry is allowed. Since NULL could mean unknown, in this case, two unknowns are not the same and I want to allow multiple nulls but I still want non null entries be unique. Is there a construct in mysql that can create a table column like this?
-- Regards, Peng
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Oct 17
Jigal van Hemert Re: Unique on non null entries but allowing multiple nulls
Oct 17, 2011; 16:13
Jigal van Hemert
Re: Unique on non null entries but allowing multiple nulls
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!