Further Question with --> table lock - which connection id own's it

Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Because what I've been doing is also: 1. lock the table 2. get the id 3

Table Locks...

Hi, Lets say that I am the admin on mysql server, how can i know which tables currently are locked? And if they are locked by someone else, how to do I remove the locks. Thank you. Rajan. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, p

Releasing a lock on table

Hi, Lets say that I am the admin on mysql server, how can i know which tables currently are being locked? And if they are locked by someone else, how to do I remove the locks. Thank you. __ Do You Yahoo!? Yahoo! Tax Center - online filing with Tur

querying check constraints

Hi, I have created a table as below: create table myTable ( Field1 int auto_increment not null, Field2 varchar(25) not null, Field2 enum('Fair','Good','Excellent'), primary key (Field1)) auto_increment=1 I would like to know how to query the table for only the enum values I have