Possibly veering off topic, but I have a strong urge to comment on this, and shall!
I am a M$ .NET developer (primarily ASP.NET with SQL Server), and have recently embarked on a project at home, and wished to apply the same sort of principles that I use at work - for example, keeping all 'system logic' embedded within the database itself. I have begun prototyping using MySQL 5.0.0a-alpha on win32 (possibly the most unstable combination you can imagine), and it is excellent. I have the odd crash, or strange glitch (such as procedures not being recognized, requiring a restart before they can be called), but this is fine - it's the first alpha, after all! Now all I need to be truly content is views.... Cheers, Matt -----Original Message----- From: Matt W [mailto:[EMAIL PROTECTED] Sent: 20 March 2004 22:57 To: Laphan; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Stored Procs and Commit/Rollback Transactions Hi Laphan, (I'm sending this to the general list too, since this isn't Windows specific and more people will see it.) MySQL 5.0, which is an early Alpha, does now support stored procedures. http://www.mysql.com/doc/en/Stored_Procedures.html And MySQL also supports transactions with the InnoDB (most common) and BDB table types. MyISAM doesn't. Hope that helps. Matt ----- Original Message ----- From: "Laphan" Sent: Thursday, March 18, 2004 5:19 PM Subject: Stored Procs and Commit/Rollback Transactions > Hi All > > OK I admit it I'm a complete MSV (MySQL Virgin), so I might be asking some > very stupid questions!!! > > I'm used to SQL Server so I think I should have a basic understanding, but > I'm sure you'll tell me different!! > > Basically I just want to confirm that the latest release of MySQL doesn't > offer stored procs or commit/rollback functionality - right? > > How does a MySQL-er get round this? > > I'm wanting to develop my ASP/Cart with MySQL as the back-bone and I'm > trying to find out what the generic do's and dont's are when using this > collaboration. > > Any feedback would be very much appreciated. > > Rgds > > Laphan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]