Create temporary table

filippo79
filippo79
edited November -1 in Support Forums

Hello everyone, I just moved a webapp (developed in php and mysql) from my old server to ProFreeHost.
I noticed I get and error when I create a temporary table, it seems like my user doesn't have the permission to create it.
I execute the same query in the SQL panel of phpMyAdmin and I get the same risult:

1044 - Access denied for user 'MYUSERNAME'@'192.168.0.%' to database 'MYDATABASE'

This is the query:

CREATE TEMPORARY TABLE TempTable AS (SELECT * FROM Memorandum WHERE stato_memo=0) ORDER BY data_scadenza_memo DESC

Can anyone help me?

Thank you very much.

Comments

  • Admin
    Admin
    edited November -1

    Unfortunately, temporary tables privilege is not granted due to the overload that can be created.

Categories