INSERT/ APPEND on a database. HOW? - Desperate for HELP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
victhour
Forum Commoner
Posts: 38
Joined: Fri Feb 17, 2006 12:59 am
Contact:

INSERT/ APPEND on a database. HOW? - Desperate for HELP

Post by victhour »

actually these is more likely backuping my database... for my Small CMS :wink: 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.

Code: Select all

INSERT INTO newDatabase.newTable SELECT * FROM Database.Table
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...
Post Reply