Clear confusion on mysql temporary table
Hi
I have a confusion. Can anyone please make me clear the confusion?
Confusion is:
Imagine I have a script that drop existing temporary table named "calculation" and create new temporary table named "calculation".
Now when user1 visits the script, it drops exiting temporary table named "calculation" and create new temporary table with the same name "calculation".
So while user1 processing his calculation, user2 visits the same script, does the user1 "calculation" temporary table drop and stop user1 process? and start user2 calculation process?
Hope you understand it. Please help me to clear the confusion.
Thank you
Subject
Written By
Posted
Clear confusion on mysql temporary table
October 31, 2021 08:44AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.