Re: join between databases

2007-07-07 Thread Dan Buettner
Miguel, it's possible, but it's not normal procedure in most systems I've worked with. Separate databases are generally used for separate "systems". Reasons include more work/steps to grant privileges to users, more difficulty establishing a test system (you need a whole separate MySQL instance i

join between databases

2007-07-07 Thread Miguel Vaz
Hi, I am building a new system for the place i work and i was thinking about organizing my tables in several databases, like "management", "financial", "production_line" to make things more tidy. I will have tons of tables, so is it a usual procedure in organizing tables? The othe