Mainly MYSQL question.. but I use php

couldn't find a mysql forum here.

[Code Sentinel]

Is it possible to create more than one temporary table at a time in MySQL within the same script?

[jpjones]

Hi,

Yes, it's possible. Just create a table as normal with the reserved word TEMPORARY, e.g.

CREATE TEMPORARY TABLENAME [blah]

The temporary table will be visible only to the connection that created it. This means that the script can be run multiple times and each script can use the same table name. Furthermore, when the connection is destroyed, the temporary table is destroyed as well.

For more information, check here: MySQL Create table documentation [dev.mysql.com]

HTH,
JP