MySQL Forums
Forum List  »  Newbie

temporary tables on mysql or Sql Server
Posted by: Rich Bernstein
Date: October 06, 2022 06:37AM

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?

Options: ReplyQuote

Written By
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.