CREATE question
- From: mrsquash2@xxxxxxxxx ("Dan Shirah")
- Date: Thu, 30 Oct 2008 15:19:12 -0400
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
- Follow-Ups:
- Re: [PHP] CREATE question
- From: Micah Gersten
- Re: [PHP] CREATE question
- Prev by Date: Re: [PHP] Mailing lists
- Next by Date: Re: [PHP] Recursive Directory Listing
- Previous by thread: How to launch a background task from a web page
- Next by thread: Re: [PHP] CREATE question
- Index(es):
Relevant Pages
|
