INSERT/ APPEND on a database. HOW? - Desperate for HELP
Posted: Tue Feb 28, 2006 1:11 am
actually these is more likely backuping my database... for my Small CMS
intend to our school campus("for News and Update").
i'd like to copy a table contents from one database to another database like the statement below. given all connection are working.
now, my confusion is how would i insert/ append another batch of data from "Database.Table" to "newDatabase.newTable"?
with accurate and quick process. coz i think the above SQL statement is a bit sloppy and slow. though im not sure with that theory
any other tips or technique aside from mysqldump and mysqlhotcopy for backuping are also appreciated.
tanx in advanced...
i'd like to copy a table contents from one database to another database like the statement below. given all connection are working.
Code: Select all
INSERT INTO newDatabase.newTable SELECT * FROM Database.Tablewith accurate and quick process. coz i think the above SQL statement is a bit sloppy and slow. though im not sure with that theory
any other tips or technique aside from mysqldump and mysqlhotcopy for backuping are also appreciated.
tanx in advanced...