From: Thufir (hawat.thufirgmail.com)
Date: Tue Mar 04 2008 - 02:58:00 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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;

thanks,

Thufir

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]