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

How MySQL Uses Table Locks

The previous code was a simple example of applying a write lock to a single table. There are also read locks. It is possible to lock any number of tables at once.

An Introduction to LOCK TABLES and UNLOCK TABLES

Here's the syntax (in simplified form) for LOCK TABLES:

LOCK TABLES table_name1 {READ | WRITE} [, table_name2 {READ | WRITE} ...]

As you can see from the syntax, you can give LOCK TABLES the names of one or more tables. Each named table requires the word READ or WRITE to specify what kind of lock the client thread should obtain on that table.

What's the difference between a read lock and a write lock?

  • If a client thread obtains a read lock, that thread and all other threads will only be able to read from that ...

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