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