InnoDB : FOR UPDATE who is locking ?

2004-07-13 Thread Jacky Pipo
Hi all,   I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?   To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, i

InnoDB : FOR UPDATE who is locking ?

2004-07-13 Thread Africable
Hi all,   I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?   To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it rel

InnoDB : FOR UPDATE who is locking ?

2004-07-13 Thread Africable
Hi all,   I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?   To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it rel