I need to copy the content from a column in one database into the matching column in another, so that the same content goes in the record with the same ID. Something like the following pseudo stuff:
我需要将内容从一个数据库中的列复制到另一个数据库中的匹配列中,以便相同的内容进入具有相同ID的记录中。类似下面的伪东西:
SET database2.table1.columnA TO database1.table1.columnA WHERE database2.id = database1.id
3 个解决方案
#1
4
You can use JOIN in an UPDATE statement:
您可以在UPDATE语句中使用JOIN:
UPDATE table1 t1
JOIN database1.table1 as t2 ON
t1.id = t2.id
SET
t1.columnA = t2.columnA
#2
14
MySQL uses syntax:
MySQL使用语法:
update database1.table1, database2.table1
set database1.table1.columnA = database2.table1.columnA
where database1.table1.id = database2.table1.id;
#3
3
if not identical columns for other people you can use the below:
如果不是其他人的相同列,您可以使用以下:
USE `old_database`;
INSERT INTO `new_database`.`new_table`(`column1`,`column2`,`column3`)
SELECT `old_table`.`column2`, `old_table`.`column7`, `old_table`.`column5`
FROM `old_table`
#1
4
You can use JOIN in an UPDATE statement:
您可以在UPDATE语句中使用JOIN:
UPDATE table1 t1
JOIN database1.table1 as t2 ON
t1.id = t2.id
SET
t1.columnA = t2.columnA
#2
14
MySQL uses syntax:
MySQL使用语法:
update database1.table1, database2.table1
set database1.table1.columnA = database2.table1.columnA
where database1.table1.id = database2.table1.id;
#3
3
if not identical columns for other people you can use the below:
如果不是其他人的相同列,您可以使用以下:
USE `old_database`;
INSERT INTO `new_database`.`new_table`(`column1`,`column2`,`column3`)
SELECT `old_table`.`column2`, `old_table`.`column7`, `old_table`.`column5`
FROM `old_table`