Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
Anthony |
| Subject: |
INSERT from db1.table SELECT db2.table? |
| Date: |
12-23-1999 06:26PM |
I'm getting an error trying to select from one database table into a different database.
Here's the syntax I'm using:
INSERT INTO databaseOne.Table (email,type,date,vers)
SELECT (email,type,date,vers)
FROM databaseTwo.Table;
Please help!
Thanks,
Anthony
ettinger@401kforum.com
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
