In 6, it clear says that unqiue can be null, but only one row.

Maybe it is a syntax mistake. what do you want? :D

i am using version 7.x
i think it is not due to the syntax,because it is success only if i add the not null to that column.
maybe the difference between two version.
i just want hava a try,dont want to do anything^o^.thanks