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) > ------------------------------------------------------------------- > DATABASE MYSQL INSTALLATION > SCHEMA DATABASE > > So in Oracle a Database is an instance running on an Oracle installation, > While with MySQL you need different installations to have different > instances(mysqld). > In my opinion Oracle naming approach is more correct, if you consider 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 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 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. > > > In your two examples: > > SELECT * FROM server.sales.schema.product; > SELECT * FROM server.product.schema.product; > > > I'm a bit tired, so maybe I'm not seeing it, but what goes in the schema > place holder? > > > -Thufir > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > "Questo messaggio ed ogni suo allegato sono confidenziali e possono essere > riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é > il destinatario diretto del presente messaggio, é pregato di contattare > l'originario mittente e di cancellare questo messaggio ed ogni suo allegato > dal sistema di posta. Se il ricevente non é il destinatario diretto del > presente messaggio, sono vietati l'uso, la riproduzione e la stampa di > questo messaggio e di ogni suo allegato, nonché la diffusione del loro > contenuto a qualsiasi altro soggetto" > ***** > "This message and any attachment are confidential and may be privileged or > otherwise protected from disclosure. If you are not the intended recipient, > please contact the sender and delete this message and any attachment from > your system. If you are not the intended recipient you must not use, copy or > print this message or attachment or disclose the contents to any other > person." > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
