On 11/10/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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] > > > Sorry, 'syntax' was the word that should be used. And thanks, renaming the table was the syntax I was looking for. Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
