Dear Benjamin, dear Michael,

> > > 1. I need to know if these features are supported or not by MySql ver
> > 4.05a.
> > > - Referencial integrity constraint

This is supported with InnoDB tables. If you _always_ need referential
integrity, simply set InnoDB tables as the default table type in my.cnf /
my.ini like this:

[mysqld]
default-table-type=innodb

> > > - Stored Procedure

General framework for this will be implemented in 4.1. Release date for
4.1-alpha: very soon (about the time when 4.0.6 will be "gamma"). Releases
are in the order "alpha - beta - gamma". Alpha will be tested as much and as
good as commercial "final" releases, whereas Gamma has a user basis which is
big enough to declare this one as Stable.

> > > - View
> > > - Trigger

Both planned for 5.0. Release date for 5.0-alpha will be summer / autumn
2003.

> I can't wait for these features too! But since some of the features are
> slated for v5.0 - v6.0, I  guess we won't be seeing them for a couple of
years.

You can already see (and use) all foreign key restraints, thus referential
integrity. You will have to wait for stored procedures until spring / autumn
2003 (alpha / gamma) and for the rest until autumn 2003 / spring 2004. So
we're not talking about years, but about months.

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


----- Original Message -----
From: "Michael She" <[EMAIL PROTECTED]>
To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Cc: "Johan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 8:22 PM
Subject: Re: MySql Feature


> At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote:
> >Hello.
> >
> >On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
> > > Hello friends, newbie here.
> > > 1. I need to know if these features are supported or not by MySql ver
> > 4.05a.
> > > - Referencial integrity constraint
> > > - Stored Procedure
> > > - View
> > > - Trigger
>
>
> I can't wait for these features too! But since some of the features are
> slated for v5.0 - v6.0, I  guess we won't be seeing them for a couple of
years.
> --
> Michael She  : [EMAIL PROTECTED]
> Mobile       : (519) 589-7309
> WWW Homepage : http://www.binaryio.com/
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to