When a database is inserted, when multiple tables are joined, it does not seem easy to do. for example, in Table a, Table B, insertintoa (text) values (hello); idprimaryasc, then an auto-increment id is generated, then I want to store this id in Table B. It seems that mysql_insert_id () can be used. However, if many people operate on this id at the same time, I don't know what the situation is, because some people say it doesn't matter, but no one is doing experiments. it seems difficult to insert data into a database when multiple tables are associated.
For example
Table a and Table B
Insert into a ('text') values ('Hello'); id primary asc
Then an auto-increment id number is generated, and the id is saved to Table B,
It seems that mysql_insert_id () can be used ()
However, if many people operate at the same time, they do not know what the situation is,
Some people say it's okay, but no one is doing experiments.
Therefore, there may be "hidden risks" and is there any convenient method?
------ Solution --------------------
Mysql does not support transactions.
------ Solution --------------------
Http://www.360doc.com/content/11/0524/16/987036_119061400.shtml.
What did this guy give you?
------ Solution --------------------
Multiple programs are detected. Mysql transaction processing. Or ajax detection!
------ Solution --------------------
You are worried. you can tell you responsibly that there are no problems you are worried about.
------ Solution --------------------
Yes. You don't have to worry about it. there are more than one person in the queue.