SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: autocommit and START TRANSACTION

  1. Mar 23, 2012 13:45 #1
    nichemtktg
    nichemtktg is offline
    SitePoint Evangelist
    Join Date
    Jun 2010
    Posts
    405
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    autocommit and START TRANSACTION

    must autocommit be turned off to use START TRANSACTION?
    Reply With Quote Reply With Quote
  2. Mar 23, 2012 14:08 #2
    nichemtktg
    nichemtktg is offline
    SitePoint Evangelist
    Join Date
    Jun 2010
    Posts
    405
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Please confirm what I think I'm reading: that START TRANSACTION implicitly disables autocommit mode for a single series of statements
    Reply With Quote Reply With Quote
  3. Mar 23, 2012 14:33 #3
    nichemtktg
    nichemtktg is offline
    SitePoint Evangelist
    Join Date
    Jun 2010
    Posts
    405
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://dev.mysql.com/doc/refman/5.0/en/commit.html explicitly says yes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules