Page 1 of 1

Handling duplicates in db

Posted: Fri Oct 29, 2010 5:14 am
by klevis miho
I have this db structure:
CREATE TABLE domain_table(
id INT NOT NULL AUTO_INCREMENT,
domain VARCHAR(255) NOT NULL,
user_id INT NOT NULL,
)

How can I make an INSERT query (without checking with a SELECT before) which adds a unique domain for a user_id?