MySQL:使用查询信息创建新表 [英] MySQL: Creating a new table with information from a query
本文介绍了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;
查询时间太长,浏览器无法显示concat,我需要使用它来进行此更新.
The query is too long for the browser to show the concat and I need this to make this updates.
推荐答案
**请注意,此方法不会创建表(根据OP标题).为此,请参见此答案.*
*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 <TABLE-1>
SELECT * FROM <TABLE-2>
您的情况应该是
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.
这篇关于MySQL:使用查询信息创建新表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文