Re: is mysql is RDBMS

Hi! MySQL-3.23.44 -Max and MySQL-4.0.0 support foreign keys through transactional InnoDB type tables. Regards, Heikki http://www.innodb.com Rick Emery wrote in message ... >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 >> >> >