Why does this query takes a lot of time

Dear Friends, I have two table joined by the followng query, the problem is this simple query takes a lot of time greater than 10 mins depending on the number of records, Pl. help me find out the reason: Table 1: id_key primary and auto increment recordID varchar(100) login_name varchar(255) blah

Re: Urgent Fetch and updation in single step/query

Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. -- Regards Abhishek Jain On 4/20/06, abhishek jain

Re: How to remove muiltiple queries to a table at the same time

Hi all, I am using PHP and what i know is that without select statement in the query we can not fetch anything . I mean if we do not give select what will be the field headers. Pl. clarify how can we fetch rfom this query. UPDATE `table_name` SET `field`=`field`+1; Also can we lock and unlock