kurt.santo Posted May 9, 2008 Share Posted May 9, 2008 I read again and again that the Inno DB storage engiens has to be used for transactions. Do they mean online payments etc?Kurt Link to comment Share on other sites More sharing options...
Synook Posted May 9, 2008 Share Posted May 9, 2008 No - transactions are a type of database operation by which a series of queries are "buffered" before execution and so do not affect the database's data itself, before you COMMIT and actually make the changes. So, if you make a mistake you can go back without wrecking the database. For a more technical explanation http://en.wikipedia.org/wiki/Database_transaction. BEGIN WORK --begin a transactionUPDATEDELETE --oops bad queryROLLBACK --operations are rolled back painlessly, no changes are made, transaction endsBEGIN WORK --(again)UPDATECOMMIT --changes are actually made to DB, transaction ends Link to comment Share on other sites More sharing options...
kurt.santo Posted May 9, 2008 Author Share Posted May 9, 2008 No - transactions are a type of database operation by which a series of queries are "buffered" before execution and so do not affect the database's data itself, before you COMMIT and actually make the changes. So, if you make a mistake you can go back without wrecking the database. For a more technical explanation http://en.wikipedia.org/wiki/Database_transaction.BEGIN WORK --begin a transactionUPDATEDELETE --oops bad queryROLLBACK --operations are rolled back painlessly, no changes are made, transaction endsBEGIN WORK --(again)UPDATECOMMIT --changes are actually made to DB, transaction ends Understood! Thanks for the clarification. Will also have a read...Kurt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.