Transaction-Safe Table Types
In much of this book, you have studied the MyISAM table type. This is the default table type for MySQL. This table type is well tried and tested; MyISAM tables are fast and compact, but they have one important limitation.
MyISAM tables have no inherent concept of transactions. They ensure safe atomic processing: They make sure that a single SQL statement can be executed without interference in the data by other threads.
But other than by locking tables, they cannot help us where we need to perform a sequence of SQL queries, all of which need to be processed to keep the data consistent. We might think of this entire sequence as a single business transaction, no part of which should be performed without performing the ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
