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 in your setup vs. a single database with a different name, ease of
creating/restoring one database in one step vs. potentially multiple steps.
You might consider prefixing table names with something to help categorize
them, like
mgmt_
fin_
prod_
You can join tables from different databases like so (assuming you have
privileges):
SELECT *
FROM database1.table1 , database2.table2
WHERE ...
HTH,
Dan
On 7/7/07, Miguel Vaz <[EMAIL PROTECTED]> wrote:
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 other problem is about doing a join between tables that are on
different databases, is that possible? For example:
database: people
table: users
fields: id, name, email
database: production
table: machines
fields: id, machine_job_num, id_user, etc
I want to do a select on table machines that gets the user names
from the table users, which is on a different databse. How can i do
it? Is it even remotely possible?
Sorry if the question is basic, but i searched the net all over
the
place and i couldnt get any answer to this.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
