CODEWITHSUNDEEP
mysqltemp-tables
Urmat
Urmat

Reputation: 37

Mysql temporary tables

Let's think that we created the temporary table. The docs says, that this table available for the current session. So, if there two or more connections with same username and password simultaneously, does the second connection have rights to access to the first data insterted by the frist connection?

Upvotes: 0

Views: 91

Answers (1)

Sal00m
Sal00m

Reputation: 2916

No, a temporary table is limited to the scope of your database connection.

You can use the same temporary table in subsequent calls of the same database connection, but other connections cannot access it.

Even, another connection can create a temporary table with the same name, when you close your connection the temporary table will dissapear

Upvotes: 2

Related Questions