Hi All I am New Subscriber to this mailing List. This is Pragneshkumar from India.
I have one Application Which are wriitten in java/jsp and using mysql as db. Now this application is running on net as well as in my intranet meand it is running on remote server as well as local server INDEPENDETLLY. Now, I have to make one module to Synchronize that two databse with minimal change in database structure(adding extrta flds in table or etc). My questions 1) Is there any way to Know to find only those records which are get changed (means update or insereted) After Some XYZ TIME. 2) Can i write any function in mysql which will call after insert or update of SOme XYZ table. Like triggers in ORACLE. 3) Can I write Interdatabase Query. like Select those Records from RemoteDB.SOMETABLE and which are not in LocalDB.SOMETABLE and insert in LocalDB.SOMETABLE Hope u will not get Angry with bunch of questions Be ===== Living on Earth may be expensive, but it includes an annual free trip round the Sun. Regards, Pragneshkumar Gandhi, India. __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- 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
