This one has been troubling me for some time now. For my project the most ideal and quickest solution to archive data is to do an insert...select followed by a delete on the original table. The problem is, I'd like my archive tables to exist in another database (makes it a lot easier on the programming side of things). That is, I have a database, let's call it "db1" and another, let's call it "db2" which would have the identically structured tables. Now ideally I'd like to do a sql query something like this...
INSERT INTO db2.table1 SELECT * from db1.table1 WHERE date < (predefined date); Is something like this possible, or am I barking up the wrong tree? Thanks. David Piasecki --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php