Hi Balaji,
I Think for MySQL 5 Version you should use Stored Procedure because in my opinion, stored procedure is faster, safer and cleaner.
The sample :
CREATE PROCEDURE TEST()
BEGIN
START TRANSACTION
Insert Into ....
Update ....
COMMIT
END
Table Type that can use Transaction is the table that using InnoDB as table Engine. MyISAM Table Engine is more appropriate for Master Table with low data transaction.
I Think you'll find more by googling.
Regards,
Shandy
"s.md.jagger hussain" <s_md_jaggerhussain@xxxxxxxxx> wrote: Hi Balaji,
This command will be execute in the mysql INNODB Engine table only ma.
Jageer
rbalaji1275 <rbalaji@xxxxxxx> wrote:
Hi,
I would like to have commit and rollback in database. I am using MySql
5.0.27-std. if any one can help me to do this.
Balaji
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
