title: MySQL Update Multiple Fields with Same Value
body: <p>I have two fields in two seperate tables that need to be updated to the same value. Without procedures, etc. Is this possible in a single query?</p>
  
  <p>Working statement:</p>
  
  <pre><code>UPDATE product,product_shop SET
   product_shop.price='737.96',
   product.price='737.96',
   product_shop.wholesale_price='479.67',
   product.wholesale_price='479.67'
  WHERE 
   product_shop.id_product=product.id_product AND
   product_shop.id_product=14;
  </code></pre>
  
  <p>What I was hoping for:</p>
  
  <pre><code>UPDATE product,product_shop SET
   product_shop.price=product.price='737.96',
   product_shop.wholesale_price=product.wholesale_price='479.67'
  WHERE 
   product_shop.id_product=product.id_product AND
   product_shop.id_product=14;
  </code></pre>