note 123006 deleted from pdo.connections by salathe

From: Date: Mon, 21 Sep 2020 14:56:26 +0000
Subject: note 123006 deleted from pdo.connections by salathe
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-215380@lists.php.net to get a copy of this message
Note Submitter: Moshe Dolev ---- Please note that you cannot use persistent connections to create temporary tables in mysql/mariadb. Tables you create using a statement like "create temporary table TABLE1 ..." are destroyed only when the mysql session ends (not php session !). This never happens if you use a persistent connection. If you create a temporary table on a persistent connection, the table will live even after the php script ends. The next php script that will try to issue the same create temporary table statement, will receive an error. IMHO, this fact makes persistent connections quite useless.

« previous php.notes (#215380) next »