Press "Enter" to skip to content

Posts tagged as “MySQL UPDATE”

How to Tune MySQL UPDATE SQL statement with IN subquery II?

I showed you how to tune an Update statement with a simple subquery in my last blog, a more complex update statement will be discussed in the following: update emp_subsidiary set emp_name=concat(‘Sub ‘,emp_name) where emp_id in (SELECT EMP_ID FROM EMPLOYEE,DEPARTMENT  WHERE DPT_ID = EMP_DEPT    AND DPT_AVG_SALARY<10000) Here the following is the query…