mySQL-使用PHP的mysqli设置隔离级别 [英] mySQL - Set isolation level using PHP's mysqli

问题描述

如何使用mysqli在PHP中将事务的隔离级别设置为"SERIALIZABLE"?我到处都看了，找不到任何信息.

How do I set the isolation level of a transaction to 'SERIALIZABLE' in PHP using mysqli? I have looked everywhere and I can't find any information on it.

此处是隔离级别的说明.

推荐答案

您可以在运行语句之前在查询中设置隔离级别.假设您使用同一会话执行所有操作:

You can just set the isolation level in a query before you run your statements. This assume that you do everything using the same session:

$mysqli = new mysqli('localhost', 'user', 'pass', 'db');
$mysqli->query("SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE");
...

您可能还想先关闭自动提交，因为它会更改可串行化隔离的工作方式.

You may also want to turn off autocommit before hand since it changes the way serializable isolation works.

这篇关于mySQL-使用PHP的mysqli设置隔离级别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！