[ale] Selecting from multiple tables
Mike Harrison
meuon at geeklabs.com
Tue Oct 4 08:50:17 EDT 2005
Mike:
> > ie: PHP and MySQL.. No. (or at least, I'm fairly sure, no.)
George:
> Wrong - you can do joins across multiple databases running on the same
> MySQL server; e.g. select * from db1.users inner join db2.groups on
> users.group_id = groups.group_id ...
Well I have to admit, I (re?)learned something. It works from the MySQL
prompt, as 'root/admin', but not from my own PHP codebase as the user that
I was using to play with normally reads specific tables only because of
database/table/user permissions. Duh.
More information about the Ale
mailing list