December 2002
Beginner
640 pages
16h 41m
English
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 ...