List:General Discussion« Previous MessageNext Message »
From:Matt Chatterley Date:March 21 2004 12:17am
Subject:RE: Stored Procs and Commit/Rollback Transactions
View as plain text  
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:mysql_lists@stripped] 
Sent: 20 March 2004 22:57
To: Laphan; win32@stripped; mysql@stripped
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/mysql?unsub=1



Thread
Re: Stored Procs and Commit/Rollback TransactionsMatt W20 Mar
  • RE: Stored Procs and Commit/Rollback TransactionsMatt Chatterley21 Mar
    • Re: Stored Procs and Commit/Rollback TransactionsMartijn Tonies21 Mar