Seriously, "function" ?? Come on, Scott, you have been at this long enough to be able to tell a function from a statement. ;-)
Are you saying that you just want to move tables from one database to another? "Combining data" has a wholly different meaning to it than simply relocating tables. The easiest way to move a table from one database to another database on the same server is to use the RENAME TABLE statement. If the destination database is on a different server, you will need to export the data you want to move to a file and re-import it at the destination. http://dev.mysql.com/doc/refman/5.0/en/rename-table.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Scott Hamm <[EMAIL PROTECTED]> wrote on 11/10/2005 09:30:45 AM: > I got two databases that do not have similiar tables and would like to > consolidate those two databases into one. What function should I use > to do that? > > Scott > -- > Please avoid sending me Word or PowerPoint attachments. > See http://www.gnu.org/philosophy/no-word-attachments.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
