I'm here to study the MySQL temporary tables, and I'm creating some temporary tables. I'm using mysqli
, according to the manual , temporary tables delete after the connection is closed.
But the truth is that this does not happen to me, temporary tables are deleted even when I do not close the connection . Is it really the behavior, or is it I'm getting the water?
PHP Code:
$mysqli = new mysqli(HOST, USER_NAME, PASSWORD, DATA_BASE);
mysqli_set_charset($mysqli, CHARSET);
$sql_create = "CREATE TEMPORARY TABLE ...";
$mysqli->query($sql_create));
//$mysqli->close();