Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-28 Thread Jeremy Zawodny
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
> Hi all,
> 
> We want to migrate to MySQL, and because of its speed, we want to use 
> MyISAM db. I plan to write code as an "alternate" transaction mechanism. 
> But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like).
> 
> In PL/SQL it is possible to use in your stored procedures transactions (at 
> the end  (eg) of a stored procedure you can do a commit and in an exception 
> handler (eg) you can do a rollback).
> 
> My question to somebody who has tried version 5 (or the development team), 
> is this possible in MySQL stored procedures too? So it is not nessecery for 
> me to write much code, but just a little and in version 5 I write my 
> transactions to stored procedures...
> 
> In anticipation much thanks!!

Didn't you ask this roughly 3 days ago?

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 538,364,636 queries (407/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-28 Thread Hans van Dalen
Excuse me,

I get an automatic reply from the mailinglist that my message wasn't send 
so I send it again.

regards
hans
At 23:50 28-9-03 -0700, you wrote:
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
> Hi all,
>
> We want to migrate to MySQL, and because of its speed, we want to use
> MyISAM db. I plan to write code as an "alternate" transaction mechanism.
> But I have read that MySQL version 5 supports Stored Procedures (PL/SQL 
like).
>
> In PL/SQL it is possible to use in your stored procedures transactions (at
> the end  (eg) of a stored procedure you can do a commit and in an 
exception
> handler (eg) you can do a rollback).
>
> My question to somebody who has tried version 5 (or the development team),
> is this possible in MySQL stored procedures too? So it is not nessecery 
for
> me to write much code, but just a little and in version 5 I write my
> transactions to stored procedures...
>
> In anticipation much thanks!!

Didn't you ask this roughly 3 days ago?

Jeremy
--
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 538,364,636 queries 
(407/sec. avg)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]