Hi, Keith Lawson <ke...@nowhere.ca> writes: > MySQL won't even let me create the situation described. While it will > allow for NULL or 0 in a primary key field it only allows for one of > them: [...] > mysql> insert into test_table (pkey,text) values ('null','test no > key'); > ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'
It's interesting that MySQL believes the string 'null' to be an integer, but I suppose you should try without the quotes. Regards, Ansgar -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org