Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Kyong Kim (kykimdbagmail.com)
Date: Tue Mar 23 2010 - 18:48:42 CDT
I need to INSERT a row into a table only if it does not exist to
insure that there won't be duplicate rows.
Due to the the usage case and the design of the primary key,
non-unique id + auto increment, I don't think insert ignore is an
What would be simplest and cheapest way to make sure that given the
create table some_table
( parent_id int //non-unique
seq_id int auto_increment ) ENGINE=INNODB
that no row with the same parent_id can be inserted?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql