Insert if not exists possible with CI?

Insert if not exists possible with CI?

El Forum
Unregistered

02-05-2010, 09:30 AM

[eluser]webnology[/eluser]
Yes, this gives me an error if I try to add the same combination again.

Error Number: 1062
Duplicate entry '10' for key 1
INSERT INTO `products2customers` (`product_id`, `customer_id`) VALUES ('10', '4133')

Messages In This Thread

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 08:43 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 08:52 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 09:00 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 09:12 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 09:30 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 10:03 AM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 03:43 PM

Insert if not exists possible with CI? - by El Forum - 02-05-2010, 04:53 PM

Insert if not exists possible with CI? - by El Forum - 02-06-2010, 12:18 AM

Insert if not exists possible with CI? - by El Forum - 02-06-2010, 04:29 PM

Insert if not exists possible with CI? - by El Forum - 02-06-2010, 06:32 PM