note 124870 deleted from mysqli.begin-transaction by cmb
| From: | cmb@php.net | Date: | Sat, 04 Apr 2020 20:30:27 +0000 |
| Subject: | note 124870 deleted from mysqli.begin-transaction by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-214417@lists.php.net to get a copy of this message | ||
Note Submitter: PHP Guru
----
In MySQL 5.6 the default access mode is READ WRITE. READ ONLY mode will not allow you to issue any
locks, even if you don't modify any tables. But the transaction can still modify or lock
temporary tables.
Starting in MySQL 5.7, it is no longer necessary to explicitly declare READ ONLY or READ WRITE
because INNODB will automatically detect the appropriate access mode for you.