Hi,
I got duplicate key violate error in the db log for the following query:
INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS (
SELECT 1 FROM tab1 WHERE id='1611576' AND id2='1187865'))
The error occured during production time.
But when I manually executed the
AI Rumman wrote:
I got duplicate key violate error in the db log for the following
query:
INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS (
SELECT 1 FROM tab1
WHERE id='1611576' AND id2='1187865'))
The error occured during production time.
But when I manually executed
On Tue, Jun 14, 2011 at 3:30 AM, AI Rumman rumman...@gmail.com wrote:
Hi,
I got duplicate key violate error in the db log for the following query:
INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS (
SELECT 1 FROM tab1 WHERE id='1611576' AND id2='1187865' ) )
The