Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Thufir (hawat.thufirgmail.com)
Date: Tue Mar 04 2008 - 02:58:00 CST
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;
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql