RE: [PHP-DB] is mysql is RDBMS

Quoting from the MySQL manual, section 6.5.3, CREATE TABLE Syntax: The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references. See section 1.4.4 Functionality Missing from MySQL -----Original Message----- From: George Lioumis [mailto:glioumis@adacom.com] Sent: Tuesday, October 16, 2001 8:20 AM To: Rick Emery Subject: Re: [PHP-DB] is mysql is RDBMS What do you mean when you say "Foreign keys are IGNORED in MySQL."? ----- Original Message ----- From: "Rick Emery" <remery@excel.com> To: <php-db@lists.php.net> Sent: Tuesday, October 16, 2001 4:16 PM Subject: RE: [PHP-DB] is mysql is RDBMS > Foreign keys are IGNORED in MySQL. The construct exists simply for SQL > compatibility, without the funcitonality. > > -----Original Message----- > From: George Lioumis [mailto:glioumis@adacom.com] > Sent: Tuesday, October 16, 2001 3:54 AM > To: php-db@lists.php.net > Subject: Fw: [PHP-DB] is mysql is RDBMS > > > > ----- Original Message ----- > From: "George Lioumis" <glioumis@adacom.com> > To: "Indianic Infotech Limited" <indianic@icenet.net> > Sent: Tuesday, October 16, 2001 10:20 AM > Subject: Re: [PHP-DB] is mysql is RDBMS > > > > The difference between a DBMS and an RDBMS is NONE!! An RDBMS is a DBMS > but > > when modelling your tables you use a Relational Entity Model. You could > have > > an OODBMS (Object-oriented DBMS). In such a case, you do not model your > data > > using tables, but objects, defining methods, private and public data, > > inheritance etc., as you would do if you wrote a program in an OO language > > such as C++ or Java. > > Oracle, for example, is an RDBMS. > > MySQL is an RDBMS (it models its tables using entities and defining > > relations between them) but does not provide you with all the set of > > services provided by a DBMS such as Oracle. > > When talking about entities and relations between them, this should not be > > considered as a physical way of storing data. It's just the way YOU, as > > designer of your DB, are modelling your data into tables. > > > > Of course, you can use Primary and Foreign keys in your MySQL to "link" > your > > tables. > > > > Hope this helps a bit. > > George. > > > > ----- Original Message ----- > > From: "Indianic Infotech Limited" <indianic@icenet.net> > > To: <php-db@lists.php.net> > > Sent: Tuesday, October 16, 2001 4:02 AM > > Subject: [PHP-DB] is mysql is RDBMS > > > > > > > Hi all, > > > > > > I read in some magzine article that mysql is RDBMS. is MySQL follow all > > > RDBMS standard rule? > > > can any one tell me what is differance in DBMS and RDBMS and why people > > says > > > that MySQL is RDBMS even MYSQL is not full DBMS. > > > I am straight forward follower of MySQL for web applications but some > time > > > we are stuck as MYSQL is not support transactions , Store & procedures > Is > > > there any way so that we can use Primary Key & Foreign Key Concept in > > MySQL. > > > > > > Regards > > > Sandeep > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >