Good add all! I want to design two database (database A and database B) to store different transactions. However both databases will store customer information. Is it possible to create one customer table for both databases to use. For example lets say database A have to insert a record in the order table using customer ID1 and database B want to use the same customer information to insert a record in a distribution table. If possible can some please give and example.

I did not try anything because I am new to MySQL