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"
>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