title: MySQL: Creating a new table with information from a query
body: <p>In MySQL, I would like to create a new table with all the information in this query:</p>
  
  <pre><code>select * into consultaa2 from SELECT
   CONCAT(    'UPDATE customers SET
   customers_default_address_id= ',    
   (SELECT a.address_book_id FROM
   address_book a where
   c.customers_id=a.customers_id order by
   address_book_id desc limit 1),    '
   WHERE customers_id = ', customers_id,
   ';') AS sql_statement FROM customers c
   where c.customers_id &gt; 3894;
  </code></pre>
  
  <p>The query is too long for the browser to show the concat and I need this to make this updates.</p>