title: MySQL Error "right syntax to use near '/*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING"
body: <p>I got this weird error after trying to execute a query on a large table:</p>
  
  <blockquote>
    <p>You have an error in your SQL syntax;
    check the manual that corresponds to
    your MySQL server version for the
    right syntax to use near '/*100,3),
    '%') AS <code>Percentage</code> FROM
    INFORMATION_SCHEMA.PROFILING WHERE
    QUERY_ID=' at line 1</p>
  </blockquote>
  
  <p>What does it mean?</p>
  
  <p>EDIT == this is the query</p>
  
  <pre><code>update cities w, states s set w.region_id = s.id 
  where s.code = w.region and w.country_id = s.country_id 
  </code></pre>
  
  <p>The cities table has around 3 million entries and the states table around 6000</p>
  
  <p>Just for the record I executed this query using a mysql client Navicat.</p>