mysql查询的同时建立新表,MySQL：使用查询信息创建新表

In MySQL, I would like to create a new table with all the information in this query:

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 > 3894;

The query is too long for the browser to show the concat and I need this to make this updates.

解决方案

*Note that this method does not create a table (as per OP title). To do that see this answer.*

Inserting into a table with information from a query is of the format

INSERT INTO

SELECT * FROM

In your case, it would be

insert into consultaa2

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 > 3894;

Just make sure the columns in the table you are inserting into and the columns returned from the select query match.