Mysql：插入SELET - 使用2个数据库服务器 [英] Mysql: INSERT into SELET - using 2 database servers

问题描述

大家好，



我想通过这个特殊的SQL查询谦虚地询问你的建议。

我想创建一个MySQL查询我可以将所有记录从一个数据库表（REMOTE SERVER）复制到数据库表（LOCAL SERVER）。我想这是MySQL Insert Into Select Statement，我在http://www.w3schools.com/sql/sql_insert_into_select.asp上找到了



例子



INSERT INTO tbl_remote_table

col_mname，col_lname，col_username，col_password，col_question，col_answer，col_email，col_status，col_photo）



SELECT col_eid，col_fname，col_mname，col_lname，col_username，col_password，col_question，col_answer，col_email，col_status，col_photo

FROM tbl_local_table



此处的问题是上面给出的示例仅适用于一个数据库中的2个表。







例如：



远程服务器：



服务器IP：'192.168。 1.149'

PORT：'3306'

USERNAME：'root'

密码：'1234'

数据库：'db_brgy_pamplonados_backup'

表：'tbl_remote_table'



LOC AL SERVER



服务器IP：'localhost'

PORT：'3306'

USERNAME：'root'

密码：'1234'

数据库：'db_brgy_pamplonados'

表：'tbl_local_table'





数据库表（REMOTE SERVER）到数据库表（LOCAL SERVER）具有以下相同的设计：



内嵌图像1









以下是我要复制的以下字段从表1到表2



col_eid

col_fname

col_mname

col_lname

col_username

col_password

col_question

col_answer

col_email

col_status

col_photo



等待您的肯定回复。







另外。我将从外部程序（VB.NET）运行所述SQL查询

因此，从预定的时间开始，程序可以将本地表副本上载到远程MySQL服务器



我尝试过：



例子



INSERT INTO tbl_admin1

（col_eid，col_fname，col_mname，col_lname，col_username，col_password，col_question，col_answer，col_email，col_status，col_photo）



SELECT col_eid，col_fname，col_mname，col_lname，col_username，col_password，col_question，col_answer，col_email，col_status，col_photo

FROM tbl_admin2

解决方案

< blockquote>阅读： mysql - 最简单的方法将表从一个数据库复制到另一个数据库？ - 堆栈溢出 [ ^ ]

Hi Everyone,

I would like to humbly ask your advice with this particular sql query.
I am trying to create a MySQL query where i can copy all records from one Database Table (REMOTE SERVER) to Database Table (LOCAL SERVER). I think it would be MySQL Insert Into Select Statement which i found at http://www.w3schools.com/sql/sql_insert_into_select.asp

Example

INSERT INTO tbl_remote_table
col_mname,col_lname,col_username,col_password,col_question,col_answer,col_email,col_status,col_photo)

SELECT col_eid, col_fname, col_mname,col_lname,col_username,col_password,col_question,col_answer,col_email,col_status,col_photo
FROM tbl_local_table

The problem here is the example given above by the source is for 2 tables in one database only.



Example:

REMOTE SERVER:

SERVER IP: '192.168.1.149'
PORT: '3306'
USERNAME: 'root'
PASSWORD: '1234'
Database: 'db_brgy_pamplonados_backup'
Table: 'tbl_remote_table'

LOCAL SERVER

SERVER IP: 'localhost'
PORT: '3306'
USERNAME: 'root'
PASSWORD: '1234'
Database: 'db_brgy_pamplonados'
Table: 'tbl_local_table'


Database Table (REMOTE SERVER) to Database Table (LOCAL SERVER) has the same design below:

Inline image 1




Below are the following fields i want to copy from Table 1 to Table 2

col_eid
col_fname
col_mname
col_lname
col_username
col_password
col_question
col_answer
col_email
col_status
col_photo

Waiting for your positive reply.



Additionally. I will run the said SQL query from an external program (VB.NET)
So that from a scheduled time the program can upload local table copy to the Remote MySQL Server

What I have tried:

Example

INSERT INTO tbl_admin1
(col_eid, col_fname, col_mname,col_lname,col_username,col_password,col_question,col_answer,col_email,col_status,col_photo)

SELECT col_eid, col_fname, col_mname,col_lname,col_username,col_password,col_question,col_answer,col_email,col_status,col_photo
FROM tbl_admin2

解决方案

Read this : mysql - Easiest way to copy a table from one database to another? - Stack Overflow[^]

这篇关于Mysql：插入SELET - 使用2个数据库服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！