Isolation and Lock Levels Supported
MySQL supports isolation levels 0 (read uncommitted), 1 (read committed), 2 (repeatable read), and 3 (serializable). The default is 1.
MySQL supports record-level locking.
Refer to "Locking and Isolation Levels" of the DataDirect Connect Series for ODBC Reference for details.