Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book