title: Create a global temporary table in mysql
body: <p>I would like to create the equivalent of this query (Oracle) in <strong>MySQL</strong>
  Can anyone help?</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE TEMP_TEST
  (
    id   VARCHAR2(50),
    id_age  NUMBER(38)
  ) ON COMMIT DELETE ROWS;
  </code></pre>