|
|
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
Navigation:
[Reply to this message]
|