Is it possible to use multiple databases in a query? (Privided that the user
has correct permissions, that is)
I have tried to use mysql as root and make a such query, and got a result.
The result, however, did look very strange.
database ccs_db.ccs_admin:
userID int unsigned
username...
I have trouble figuring out how the indices are used when making a query
that uses OR-operator.
If I have the following table:
create table testing(
id int unsigned not null primary key auto_increment,
idx1 int unsigned not null,
idx2 int unsigned not null,
index(idx1),
index(idx2));
In this