On Fri, 7 Dec 2001 03:07:56 -0800 (PST), Pragneshkumar Gandhi <[EMAIL PROTECTED]> wrote: | 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.
Yes, put a timestamp field in the table. | 2) | Can i write any function in mysql which will call after | insert or update of SOme XYZ table. | Like triggers in ORACLE. Not in the current version, maybe in version 4.1 http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html | 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 Not via sql, since left joins need to be done on tables on same server. This is due to the fact that one query can not take 2 connection handlers. | Hope u will not get Angry with bunch of questions Not a problem. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 <? Special Projects Programming Manager ?> --- Intercosmos Media Group, Inc. --- www.intercosmos.com www.directnic.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
