Re: Do SELECT statements create some kind of row/table lock?

[Aftab Khan]

>I have a table with a large number of rows (more than 14 million) and 4 indexes
Please provide following for the subject table:
SHOW CREATE TABLE table_name\G
SHOW TABLE STATUS LIKE 'table_name'\G
SHOW index from table_name\G

Please provide full SELECT query including correlated subquery, please provide EXPLAIN output for the same query too. Also provide UPDATE query