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]