table lock while creating table using select
- by shal
Using mysql version 5.0.18
I am creating a table TT,
Client 1
set autocommit = false;
start transaction
Create table TT select * from PT;
PT has tow columns pk bigint not null,name varchar(20)
Client 2
set autocommit = false
start transaction
insert into PT values(123,'text');
While inserting a row in PT , it is waiting for the table Client 1 to commit. I am unable to insert the row. why? Is it possible to insert the row without waiting for Client 1 to commit.
