temporary tables on mysql or Sql Server
Hi. I am using Codigniter 3 and my app builds 7 temp tables for use in presenting a Koolreport report. My plan was to do this with temp tables since they will be removed when the user logs off and for speed purposes.
I have found that doing a CREATE TEMPORARY in CI3 doesn't work. NO error, the table is just not created. But when I take the same sql statement and use mysqlWorkbench, it creates fine. Seems to be a CI3 bug, to me. BTW, I am using RDS.
I am thinking that perhaps switching to Sql server on RDS will solve this. Has anyone had success using TEMPORARY tables with CI3?
Subject
Written By
Posted
temporary tables on mysql or Sql Server
October 06, 2022 06:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.