在MySQL中，如何将一个表的内容复制到同一个数据库中的另一个表？ [英] In MySQL, how to copy the content of one table to another table within the same database?

问题描述

我是新的MySQL。我想将一个表的内容复制到同一数据库中的另一个表。基本上，我想从另一个表插入到表。

解决方案

INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;

编辑：如果表格具有不同的结构，您也可以：

  INSERT INTO TARGET_TABLE（`col1`，`col2`）SELECT`col1`，`col2` FROM SOURCE_TABLE; 
  

编辑：约束这个...

  INSERT INTO TARGET_TABLE（`col1_`，`col2_`）SELECT`col1`，`col2` FROM SOURCE_TABLE WHERE`foo`= 1 
  / pre> 
I am new to MySQL. I would like to copy the content of one table to another table within the same database. Basically, I would like to insert to a table from another table. Is there easy way of doing this?
解决方案
INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;

EDIT: or if the tables have different structures you can also:
INSERT INTO TARGET_TABLE (`col1`,`col2`) SELECT `col1`,`col2` FROM SOURCE_TABLE;
EDIT: to constrain this..
INSERT INTO TARGET_TABLE (`col1_`,`col2_`) SELECT `col1`,`col2` FROM SOURCE_TABLE WHERE `foo`=1


                        
这篇关于在MySQL中，如何将一个表的内容复制到同一个数据库中的另一个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！