Lets say I have 2 columns in table1
Id is obviously primary but I want Value to be unique....
I tried "NOT EXISTS" with a subquery but I cant really seem to get it to work. It would be something like
INSERT INTO table1(value) WHERE VALUES('3');
From then on I dont want 3 to be inserted again in the Value column. I dont care about the ID column.
How do I do this in MySQL?
Thanks for the help