Comparison - SQL Server and MySQL 1

[Ovatvvon]

Hi All,

I'm pretty familiar with SQL Server 2000 and 2005, but not familiar with MySQL at all. SQL Server has a system database called TempDB, which is used specifically to hold temporary tables by anyone on the system, and it will automatically drop those tables once the connection that created it is broken. This allows for greater performance, and manageability of data.

I am wondering if MySQL has anything like this built in?


-Ovatvvon :-Q

 

[elsenorjose]

Yes.

They are private to a connection. No other connection can see them, and there are no naming conflicts when many connections create temporary tables with the same name.

They go away by themselves when the connection closes, so you don’t have to clean up after crashed connections.

Not sure exactly where the metadata about the tables is stored, though.

 

[Ovatvvon]

Thanks!

-Ovatvvon :-Q