Je viens de regarder ta solution mais je pense que ca va poser probleme avec mon appli car j'ai un pool de connection...
From MySQL 3.23 on, you can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) From MySQL 4.0.2 on, you must have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables.
[^] # Re: Table temporaire
Posté par superbamboo . En réponse au message base de donnée sans persistence. Évalué à 1.