A Little Noise

November 13, 2005

Unique Index

Filed under: MySQL Gotchas — snoyes @ 4:00 am

If I run the following, what will happen?

CREATE TABLE myTable (someField int, UNIQUE (someField));
INSERT INTO myTable VALUES (null);
INSERT INTO myTable VALUES (NULL);

Show Answer ▼

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress