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.
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 :)
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)
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.
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.
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.
I suggest you start a discussion on phpmyadmin-devel about this, to gather more ideas.