note 123006 deleted from pdo.connections by salathe
| From: | salathe@php.net | 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.