Hi,
I'm not sure if this reply to your problem, but it will surely put you
on the correct answer.
http://dev.mysql.com/doc/mysql/en/InnoDB_Next-key_locking.html
Philip Ross wrote:
MySQL 4.1.8
I have an InnoDB table with a unique constraint:
CREATE TABLE TEST (
ID bigint NOT NULL
MySQL 4.1.8
I have an InnoDB table with a unique constraint:
CREATE TABLE TEST (
ID bigint NOT NULL auto_increment,
NAME varchar(100) NOT NULL,
VALUE varchar(100),
PRIMARY KEY (ID),
UNIQUE KEY IX_NAME (NAME)) ENGINE=InnoDB
Given a particular unique name, I need to either find the