- Thu Apr 11, 2019 7:16 am
#823964
Hi,
Grateful if I can be advise whether MySQL Temporary Table is support in PM Bitnami 3.2.1 Linux version.
I found the following sql work directly in the MySQL of the installation.
mysql> CREATE TEMPORARY TABLE TMP AS ( SELECT MEMNO, NAME FROM PMT_MEMBER WHERE NAME = 'Albert' );
MySQL could create a temporary table with all the rows where NAME = "Albert" and the temporary table TMP can be used normally as a table in that session.
However, when I put it in PM with the following statements,
$sql = "CREATE TEMPORARY TABLE TMP AS ( SELECT MEMNO, NAME FROM PMT_MEMBER WHERE " . $memname . " )" ;
$res = executeQuery($sql) ;
where $memname is a string with value "NAME = 'Albert' ",
$res returned false and the temporary table TMP could not be found.
How could I create and use temporary tables in a session?
Many Thanks
cheers,
Karl
Grateful if I can be advise whether MySQL Temporary Table is support in PM Bitnami 3.2.1 Linux version.
I found the following sql work directly in the MySQL of the installation.
mysql> CREATE TEMPORARY TABLE TMP AS ( SELECT MEMNO, NAME FROM PMT_MEMBER WHERE NAME = 'Albert' );
MySQL could create a temporary table with all the rows where NAME = "Albert" and the temporary table TMP can be used normally as a table in that session.
However, when I put it in PM with the following statements,
$sql = "CREATE TEMPORARY TABLE TMP AS ( SELECT MEMNO, NAME FROM PMT_MEMBER WHERE " . $memname . " )" ;
$res = executeQuery($sql) ;
where $memname is a string with value "NAME = 'Albert' ",
$res returned false and the temporary table TMP could not be found.
How could I create and use temporary tables in a session?
Many Thanks
cheers,
Karl