Jump to content


This topic is now archived and is closed to further replies.


Temporary Tables???

Recommended Posts

If I do a query that create a temporary table like this

$result = mysql_query("create temporary table SILK (Select
From products Inner Join runtimes ON runtimes.PN = products.PART_NO)");

then I do another query that creates a second temporary table ,

can you have more than one temporary table? or does it destroy the old one?

Share this post

Link to post
Share on other sites
From looking at [a href=\"http://dev.mysql.com/doc/refman/5.0/en/temporary-table-problems.html\" target=\"_blank\"]Temporay Table lmitations[/a] over at mysql.com it looks you can create multiple temporay tables.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.