title: Update to Mysql table w/ Inner Join on Information Schema not allowed
body: <p>So I'm trying to update a table that I've created with a join statement to Information schema.
  The following is the code that gives the error: <code>ERROR 3550 (HY000): Information schema queries do not support the 'FOR UPDATE' clause.</code></p>
  <pre><code>UPDATE progress.db_progress dp
   INNER JOIN  information_schema.tables t
   ON dp.table_name = t.TABLE_NAME
   set dp.already_done = (SELECT
     CASE
       WHEN t.TABLE_ROWS &gt; 0 THEN 1
       ELSE 0
     END)
   WHERE t.table_schema = 'sanitizedfooname';
  </code></pre>
  <p>And for completeness sake, the following is the table desc:</p>
  <pre><code>+-----------------+--------------+------+-----+---------+----------------+
  | Field           | Type         | Null | Key | Default | Extra          |
  +-----------------+--------------+------+-----+---------+----------------+
  | id              | int          | NO   | PRI | NULL    | auto_increment |
  | table_name      | varchar(255) | YES  |     | NULL    |                |
  | needs_migration | tinyint(1)   | YES  |     | NULL    |                |
  | already_done    | tinyint(1)   | YES  |     | NULL    |                |
  +-----------------+--------------+------+-----+---------+----------------+
  </code></pre>
  <p>Obviously I'm not <em>trying</em> to update the information schema, but it seems to think I am. Also, I could have sworn I had run the query before and it worked, but now I question my sanity, I mean memory. This is on AWS RDS, MYSQL 8 if that makes any diff.</p>
  <p>So... why does it say paper-jam when there is no paper-jam?</p>