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