Re: table myisam and roll back?
At 19:45 -0800 12/17/02, CN YEONG wrote: Hi, May I know that if it is posibble to roll back the sql query automatic if the sql query get error by using myisam table type and not using innodb type? No. MyISAM isn't a transaction-safe table type. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table myisam and roll back?
CN YEONG wrote: Hi, May I know that if it is posibble to roll back the sql query automatic if the sql query get error by using myisam table type and not using innodb type? Thank for help. No. You need to use a transactional table handler, like InnoDB. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table myisam and roll back?
Hi, May I know that if it is posibble to roll back the sql query automatic if the sql query get error by using myisam table type and not using innodb type? Thank for help. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php