MySQL Forums
Forum List  »  MySQL Query Browser

Transfer Data
Posted by: Mike Siconolfi
Date: March 29, 2012 07:55AM


i need to be able to transfer data from a table on another DB server to a local DB. CUrrently the process is querying the table for the last date:

SELECT from_unixtime(timestamp) FROM DB1.table order by from_unixtime(timestamp) desc limit 1

2012-03-21 12-23-56

Now i need to use that to import from another DB located off site everything from that date on into the local DB for that table.

SELECT * FROM DB.table where from_unixtime(timestamp) > '2012-03-21 12-23-56'

What i dont know how to do is actually do this all from a query browser on my local DB automatically without me having to input the date manually.

Options: ReplyQuote

Written By
Transfer Data
March 29, 2012 07:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.