My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS is different in this regard. Microsoft's SQL Server works like
this:
A SQL Server instance ("server") can have many databases.
A database can have many schemas, schema simply being a grouping for
objects in a database. In a SQL Server 2005 database, there can be two
tables named "Product" if one is in the schema Sales and the other is in
the schema Manufacture. The two tables are Sales.Product and
Manufacture.Product.
A fully qualified SQL Server object name is
server.database.schema.object.
-----Original Message-----
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Thufir
Sent: Tuesday, March 04, 2008 12:58 AM
To: mysql@lists.mysql.com
Subject: Re: what is a schema? what is a database?
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_Schema
s_.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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
