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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
