how to get the timestamp from remote mysql

Hi guys I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone? that is to say I set the date and send itto remote ser

how to fetch and calculate data from remote database and insert into local database

Hello I want to fetch and calculate the data from remote database(for example Japan) and insert them into my local database(for example usa), does mysql have such function to do it, or do I have to write a script using perl or other language to help achieving it? thank you in advance nathan

how to add foreign key in alter command

Hi guys Please tell me the command syntax, how to add a colmmen foreign key in alter syntax thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org