title: UPDATE with ORDER BY and LIMIT not working in MYSQL
body: <p>I am new to MYSQL, and unable to resolve or even with so many answers on this forum, unable to identiy the error in this statement. I am using MYSQL database.</p>
  
  <p>I have 2 tables: Ratemaster and rates, in which a customer can have 1 product with different rates. 
  Because of this, there is a duplication of customer and product fields, only the rate field changes.
  Now Table Ratemaster has all the fields : id, Customer code, Product, Rate, user
  whereas Table Rates has only:             id, cust code, Rate, user.
  - user field is for checking session_user.</p>
  
  <p>Now Table Ratemaster has 3 records with all field values being same except Rate field empty.
  Table Rates has different rates.
  I want to have all rates to be updated in Ratemaster from Rates table. I am unable to do this with <code>UPDATE</code> and <code>LIMIT</code> mysql command, it is giving error as: </p>
  
  <blockquote>
    <p>Incorrect usage of UPDATE and LIMIT</p>
  </blockquote>
  
  <pre><code>UPDATE Ratemaster, Rates 
  SET Ratemaster.Rate=Rates.Rate 
  WHERE Ratemaster.user=Rates.user 
  LIMIT 1
  </code></pre>