Handling duplicates in db
Posted: Fri Oct 29, 2010 5:14 am
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?
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?