Thanks but this doesn't help I have no choice to run these two applications. I would prefer it if someone could help with the question in hand:-
Is it possible to create a means by which these two table populate each other. Charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Horvitz Sent: 08 November 2005 17:05 To: [email protected] Subject: Re: [php_mysql] Keeping different databases synchronised in MySQL4 What I would do if you wanted just one database for your customers, use seperate IDs for each application...app1 uses cust_id1 and app2 uses cust_id2 or something like that Pete <[EMAIL PROTECTED]> wrote: In message <[EMAIL PROTECTED]>, Charlie Markwick <[EMAIL PROTECTED]> writes >I am a relative newcomer to MySql and to be honest any sort of Database >admin. > >I have two separate applications that use their own databases. Each >have a table called Customer. The fields in each table are different >but contain similar data. > >The data held in each of these tables is for an identical customer >group. It is time consuming to enter the data twice. Is there any way I >can get these different tables to update each other automatically >perhaps by using a third intermediate table/database? > >Charlie Could you use ONE table for customers? MySQL databases on the same server should have no problems about seeing each other. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. SPONSORED LINKS American general life and accident insurance company American general life insurance company American general life American general mortgage American general life insurance Computer internet security --------------------------------- YAHOO! GROUPS LINKS Visit your group "php_mysql" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Jay Horvitz 309-253-8750 (cell) [EMAIL PROTECTED] --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
