#532 Multiple DB sql query

[Matthew Schultz]

I run multiple websites on a server and I use the same
code across multiple databases. I thought it would be
nice to be able to execute a query across multiple
databases and to possibly pick and choose which
databases to apply the query.

[Sathia]

Logged In: YES
user_id=1012096

it would be wonderful to store last #x query in the sidebar.
or to group them in a row.

so that you can create little routine to test your db :)

[Marc Delisle]

Logged In: YES
user_id=210714

Sathia,

When you activate the pmadb features, you get

- a bookmark system
- a permanent history of your queries
(not in a sidebar but in the Query window)

[Rakesh Kumar]

Hi Marc,
I think it would be nice to add a dropdown containing all the databases near query box to select database(s) in which query is to be executed.

It will be default to current database selected and if none is selected then user would have option to select any.I would like to work on it.

[Marc Delisle]

Hi Rakesh,
this would be problematic if the user has access to hundreds and even thousands of databases, as is often the case with the MySQL root user on shared hosting.

[Rakesh Kumar]

We can manage it by configuration file,User can decide on basis of their conveniency .
Or we can set a limit for number of databases (say 10) for showing it.

[Marc Delisle]

I suggest you start a discussion on phpmyadmin-devel about this, to gather more ideas.