Re: is mysql is RDBMS

Hi! Rick Emery wrote in message ... >Prior to version 4.0, INNODB was compiled in only the mysql-max binary, not >the standard binary. Most web-hosts, and virtual web-hosting companies, do >not run the -MAX version. Therefore, there was no access to innodb >databases. Well, many users download MySQL from www.mysql.com There you can download 3.23 -Max as easily as plain 3.23. For example, www.slashdot.org runs on MySQL/InnoDB. >As we stated in threads yesterday, version 4.0 is not ready for prime time. >It was an ALPHA release (read: bug-ridden) and is unstable (under >development). This is NOT the version you want to use for mission-critical >applications. > >When version 4.x, golden version, is released, then it might be usable. >Along with INNODB. Regards, Heikki Innobase Oy >-----Original Message----- >From: Heikki Tuuri [mailto:Heikki.Tuuri@innobase.inet.fi] >Sent: Thursday, October 18, 2001 3:38 PM >To: php-db@lists.php.net >Subject: Re: [PHP-DB] 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 >>> >>> >> > > > >-- >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 > >