Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP MYSQL事宜会并发吗

PHP MYSQL事宜会并发吗

WBOY
Release： 2016-06-13 13:21:37
Original
874 people have browsed it

PHP MYSQL事务会并发吗
假如有A表和B表。

向B表插入数据的前提是先判断A表。

如果在程序上先判断A表，然后再进行插入数据就发生了并发。。

如果做成事务，插入数据以后再去判断A表，如果条件不符，再回滚。。。  

这样能解决么，好像还是会并发？



------解决方案--------------------
用select ... for update
------解决方案--------------------

探讨

用select ... for update
Related labels：
for mysql nbsp select update
source：php.cn
Previous article： 求解变为w+横线 Next article： mysql 数据迁移有关问题，所有的.frm文件报错·
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
sql groupby not working, I want to group by code_branch ->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameas...
From 2024-04-06 19:24:49
0
2
488
An error was encountered while trying to retrieve the latest version of a package from search.maven.org "Error: Unable to retrieve data from Maven repository" while retrieving latest v...
From 2024-04-05 12:11:23
0
1
1471
Modify matSelect style when displaying options How to change properties of mat-select when option is on? <mat-selectclass="select...
From 2024-04-05 09:23:19
0
1
1374
Echo inside div with nested echo I'm trying to use echo<?phprequire'connect.php';$query=mysqli_query($conn,"SELECT*...
From 2024-04-04 11:09:23
0
1
390
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template