extracting new data only

[Anon]

Hi,

How would I do this ?

I have a MySQL database with a lot of data and I need to extract only the data that has been updated or added in the last 24 hours. The I need to take this data and insert it into another MySQL database. (I have a timestamp against each record)

Any ideas would be very welcome.

Cheers

[bastien]

select * from table where time>(now()-86400)

will get you everything posted in the last 24 hours (86400 seconds)

hth

bastien

[Anon]

Depending on the format you have the date in, you may need to do this for it to work:

SELECT * FROM table_name WHERE date >(UNIX_TIMESTAMP(now()) - 86400)

Richie.
geocities.com/akindele/