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
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to