List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 4 2008 3:48pm
Subject:Re: what is a schema? what is a database?
View as plain text  
At 8:58 AM +0000 3/4/08, Thufir wrote:
>On Mon, 03 Mar 2008 14:20:58 -0500, Martin Gainty wrote:
>
>>  http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to
>>  MYSQL doc:
>>  A schema is a database
>
>
>That contradicts the following claim (to my reading):
>
>
>"A true fully (database, schema, and table) qualified query is
>exemplified as such: select * from database.schema.table"
>
>http://en.wikipedia.org/wiki/
>Comparison_of_relational_database_management_systems#Databases_vs_Schemas_.28terminology.29
>
>What' I'm familiar with is:
>
>SELECT * FROM database.table;
>
>That's ok, that makes sense, this is how MySQL does it and is how I've
>been doing it.  Some databases do it differently, apparently.
>
>
>Apparently MySQL lacks this feature, but what feature is it lacking? 
>There's no equivalent to:
>
>SELECT * FROM database.schema.table;


In MySQL, the two are equivalent.  The keyword DATABASE or DATABASES
can be replaced with SCHEMA or SCHEMAS wherever it appears. Examples:

CREATE DATABASE <=> CREATE SCHEMA
SHOW DATABASES <=> SHOW SCHEMAS

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
what is a schema? what is a database?Thufir2 Mar
  • Re: what is a schema? what is a database?bmurphy2 Mar
  • Re: what is a schema? what is a database?Martin Gainty3 Mar
  • Re: what is a schema? what is a database?Thufir4 Mar
    • Re: what is a schema? what is a database?Paul DuBois4 Mar
  • Re: what is a schema? what is a database?Thufir5 Mar
    • Re: what is a schema? what is a database?Joerg Bruehe5 Mar
  • Re: what is a schema? what is a database?Thufir5 Mar