On Fri, Nov 11, 2005 at 10:59:56AM -0500, Barbara Deaton wrote:
> I didn't think MySQL had the concept of a "schema" for example with
> SQL Server you can have a database (or Catalog) called "accounts" and
> within it have two tables user1.employees and user2.employees, where
> user1 and user2 are the schema's.
>
> Since MySQL tables are db.tablename this seems to indicate that the
> result set would have db returned as the catalog and nothing as the
> schema.
>
> Is this correct behavior?
Yes. In MySQL 5.0, database and schema are synonymous.
There is no support for catalogs at this time.
Jim Winstead
MySQL Inc.
