1

InnoDB supports transaction and MyISAM does not support transaction. I don't understand how it does and does not support transaction.Can anyone explain with example. Thanks in advance.

Swetha Sekar
  • 237
  • 1
  • 9
  • 1
    See : https://stackoverflow.com/questions/8036005/myisam-engine-transaction-support – the-juju Dec 05 '19 at 12:58
  • I want any example – Swetha Sekar Dec 05 '19 at 13:09
  • An example of what, exactly? It's just a feature. With MyISAM, you cannot execute a transaction against the table. It will just ignore any rollback commands. And it will immediately save any DML statements, without waiting for a commit statement. The reason for that is due to how the table types are designed. Everything you need to know is already in the link which Julien posted, above. Did you read it?? – ADyson Dec 05 '19 at 13:18
  • S i saw the link – Swetha Sekar Dec 05 '19 at 13:26
  • Ok. And now you have read it, is there something specific which you still don't understand? Please be clear about what you are really asking. Because according to your question above, the answer is already contained in that link. – ADyson Dec 05 '19 at 13:49
  • S got it.Thank you – Swetha Sekar Dec 06 '19 at 04:40

0 Answers0