Insert Into

[mikeC4359]

Hello,
I like if someone can help me with this question.

Using a SQL Statment I like to preform a "INSERT INTO" and a "SELECT" at the same, but the "INSERT INTO" and the "SELECT" are in 2 different databases. I'm using MYSQL 3.23.45 NT.
Thanks in advance

Mike C.

 

[tlbroadbent]

I'm not familiar with MySQL. You should be able to use a 3-part table name. The standard SQL should look like the following.

Insert Into db1.owner.table
Select * From db2.owner.table

If this doesn't help, I suggest posting your question in the MySQL forum (forum436) and/or referencing the MySQL documentation. If you don't have documentation, yo can find it at

http://www.mysql.com.

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[mikeC4359]

Thanks, Ill give it a try...

Mike C.