title: Do DMLs in a stored procedure run in a single transaction?
body: <p>My MySQL 5.5 server has set <code>autocommit=1</code>.</p>
  
  <p>My stored procedure has several DMLs but without explicit transaction management.</p>
  
  <p>When I issue <code>call the_procedure()</code> from MySQL CLI (<code>autocommit</code> is still 1), do all the procedure's DMLs run in one transaction?</p>
  
  <p>Or do they run in separate transactions, and causing implicit transaction commit after every DML (due to autocommit)?</p>