a
Database as a RDBMS, anyway, MYSQL IS GREAT!
Aloha!
Claudio Nanni
-Messaggio originale-
Da: news [mailto:[EMAIL PROTECTED] Per conto di Thufir
Inviato: mercoledì 5 marzo 2008 12.09
A: mysql@lists.mysql.com
Oggetto: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar
: Re: FW: Re: what is a schema? what is a database?
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio [EMAIL PROTECTED] wrote:
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father [EMAIL PROTECTED] wrote:
Schema is a collection of databases.
A schema is a definition of tables fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
:[EMAIL PROTECTED] Per conto di Thufir
Inviato: mercoledì 5 marzo 2008 12.09
A: mysql@lists.mysql.com
Oggetto: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS
On Tue, 04 Mar 2008 09:48:03 -0600, Paul DuBois wrote:
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
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
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
Hi Thufir, all !
Thufir wrote:
On Tue, 04 Mar 2008 09:48:03 -0600, Paul DuBois wrote:
[[...]]
In MySQL, the two are equivalent. The keyword DATABASE or DATABASES can
be replaced with SCHEMA or SCHEMAS wherever it appears.
Right, but that wasn't exactly what I was asking. I'm fairly
believe he
is correct.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Thufir
Sent: Wednesday, March 05, 2008 3:09 AM
To: mysql@lists.mysql.com
Subject: Re: FW: Re: what is a schema? what is a database?
On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote:
My
=tpuhsicnt5h5helm
Buena Suerte/Viel Gluck
Martin
- Original Message -
From: Garris, Nicole [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, March 05, 2008 10:33 AM
Subject: Re: what is a schema? what is a database?
Sorry. An example of a fully qualified SQL Server object name
Hi !
Martin Gainty wrote:
my understanding is that Namespace is a defined grouping of classes
http://m5.eecs.umich.edu/docs/namespaceMySQL.html
My use of the term name space was much more generic, similar to how
compilers use it:
When you define a record type (C: struct, Pascal: record,
On Wed, 05 Mar 2008 15:01:12 +0100, Joerg Bruehe wrote:
I have not heard of a three level naming scheme yet.
Aha, thanks for the history, helps to put what I was reading into context.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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
-
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
At 8:58 AM + 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,
http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html
According to MYSQL doc:
A schema is a database
Wikopedia says a Schema is defined as:
Pronounced as skee-ma, the structure of a database system, described in a
formal language supported by the database management system (DBMS). In a
Yes, you are exactly right. The schema is the structure of the database.
Keith
I've been referencing a variety of sources, including wikipedia. What I
know about a schema is that in SQLite the .schema command will show the
the SQL structure of that databases tables, which would be analogous
as far as I know a schema is a description of a database.
[EMAIL PROTECTED] wrote:
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A schema is a the database design. Sometimes textual, sometimes visual
definition of the database structure (tables, field types, defaults etc). The
database is the physical implementation of the schema that holds the data.
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
On Wed, Aug 03, 2005 at 03:30:19PM +0100, Juan Pedro Reyes Molina wrote:
as far as I know a schema is a description of a database.
In ORACLE terms, a schema is a grouping of database objects
(tables, indexes, and so on). It is synonymous with user in
ORACLE. A given ORACLE instance can contain
Message-
From: Jason Martin [mailto:[EMAIL PROTECTED]
Sent: 03 August 2005 15:33
To: mysql@lists.mysql.com
Subject: Re: What is a schema?
On Wed, Aug 03, 2005 at 03:30:19PM +0100, Juan Pedro Reyes Molina wrote:
as far as I know a schema is a description of a database.
In ORACLE terms, a schema
[EMAIL PROTECTED] wrote on 08/03/2005 10:20:36 AM:
What is a schema? How is different from a database?
As I understand it, and some scholars may disagree with me, a schema is
(most often) a description of a data structure. A database IS a data
structure composed of tables and other possible
21 matches
Mail list logo