sathishnadu

Can anyone explain me on details the difference of Deadlock and Lockwait errors found on MySQL 5.1. Is it just the same? When did the deadlock error occur and when did the lockwait timeout occur?

Should store procedure cached in Mysql? If yes, How long it is stay in cache? In my case, When I call one store procedure first time, It is giving me result in 1sec, after that it gives me result in 400ms. and when I am changing some parameters passed to …

I have a query: SELECT b.user_id, b.active FROM users b WHERE b.followers_count != (SELECT COUNT(*) FROM (SELECT u.user_id FROM user_follow uf,users u,user_follow_request ufr WHERE uf.following_id = b.user_id AND uf.following_id = ufr.friend_id AND ufr.status = 'approved' AND ufr.user_id = u.user_id AND u.user_id != b.user_id AND u.active != 0 GROUP BY u.user_id) …

Hi I am not understanding , why the subquery of given query is converting into dependent subquery. Although the subquery is not dependent(not using primary query table) on main query. I know that this query can be optimized using joins,but here i just want to know the reason of this …

I am updating a summary table from detail table using inner join as follows drop TEMPORARY table if exists summ ; drop TEMPORARY table if exists det ; create TEMPORARY table summ (id int , val int ) ; create TEMPORARY table det (id int , val int ) ; …

I have two tables: Subscriber_detail SubscriberID | Merchant_ID 23 | 24 User_Detail User_ID | User_RegisteredID 23 | 1001001 24 | 1001002 Need to fetch User_RegisteredID from User_Login table for SubscriberID and Merchant_ID from Subscriber_Detail

Can any one guide me as I what a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name