MySQL Forums
Forum List  »  Newbie

Clear confusion on mysql temporary table
Posted by: Syed Imran Ertaza
Date: October 31, 2021 08:44AM

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

Options: ReplyQuote


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.