Posted by Hugo Kornelis on 12/05/07 18:30

On Wed, 05 Dec 2007 16:31:37 GMT, judy wrote:

>I have several databases that are used to collect data for different
>client-projects. My intention was to collect the data, and administer
>mySQL so each client could see only their data. Each of these
>databases used to collect data have the same tables. There are other
>databases which are available to all the users which contain common
>information.
>
>The command "show databases" lists all of the databases (visible to
>the particular user) and not the one's I would like to display (the
>databases used to collect data). Is there a way to nest a single
>mySQL command to show only the databases that have the same particular
>table?

Hi Judy,

This group is intended for supporting MS SQL Server users. Since you are
refering to mySQL and mentioning a "show databases" command that SQL
Server doesn't have, I'm going to assume that you came here by accident.

You'll probably get better help if you post in a mySQL group, for
instance in comp.databases.mysql.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]