Sams Teach Yourself MySQL in 21 Days, Second Edition

Summary

Today's lesson showed you a number of things:

• You learned how to perform table locking using LOCK TABLES, using both read and write table locks.

• You learned how to use the GET_LOCK() function to perform cooperative locking between applications, or between different instances of the same application.

• You had an introduction to MySQL's transaction-safe table types; you learned how to install InnoDB; how to create an InnoDB table; and how to use the BEGIN, COMMIT, and ROLLBACK commands to manage a multiquery transaction.

Running transaction-based queries is a large subject area. Today you had just a brief introduction to the subject, but by following the practical example given, you should have a good grasp of what transaction processing enables ...