CREATE question
| From: | Dan Shirah | Date: | Thu, 30 Oct 2008 19:19:12 +0000 |
| Subject: | CREATE question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-282646@lists.php.net to get a copy of this message | ||
All,
Is it possible for us to use PHP to create temp tables in our database?
Ironically, up until this point I have only needed to use SELECT statements.
But now, to speed up the processing time of a large query I would like to
create a temp table and then reference the temp table in another query.
I've tried stuff like the below:
$temp_query = "create temp table my_temp_table(
date date,
code char(3),
loc char(3),
time DATETIME HOUR TO MINUTE,
matter_id int,
name char(25)
) WITH NO LOG";
$do_query = ifx_query($temp_query, $connect_id);
But all that does is give me an "ifx_prepare fails" message.
Can we not use the ifx_query, mssql_query, mysql_query functions to create
tables?
Can they only be used to select data?
Thanks in advance,
Dan