Hi,
I'm running mysql version 4.0.13 and trying to create a temporary table
from a php script. For some reason, even though I have the permission
set up correctly, I can't seem to create a temporary table from the
script. The permission say that create_tmp_table_priv=Y for the user in
my connectio
I am ausuming you are using the same user from both PHP and the mysql client.
But are you doing both locally? There may be two user records, one for
localhost and one for remote connections (or something to that effect).
Just a thought.
-Jackson
On Monday 11 August 2003 1:52, Miretsky, Anya
"Miretsky, Anya" <[EMAIL PROTECTED]> wrote:
>
> I'm running mysql version 4.0.13 and trying to create a temporary table
> from a php script. For some reason, even though I have the permission
> set up correctly, I can't seem to create a temporary table from the
> script. The permission say that cr
> > Further to this, I should point out everything works fine in mysql-front
> > or at the mysql console.
> >
> > The problem shows up when using mysql++, a BadQuery exception is thrown.
> >
> > query.reset();
> > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
> >
; " TYPE=HEAP
MAX_ROWS=1 " << subselect;
try
{
query.parse();
query.execute();
}
- Original Message -
From: "Phil Bitis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 12:41 PM
Subj
As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to v4.0.1
Hello everyone,
I am running MySQL version 3.23.52 on Mandrake 9.0 and access it from a web
application running on IIS on Win 4.0 Service pack 6a with MyODBC version
2.50.39.
The problem I am having is when I create a temporary table and then query
the temporary table I get a Table doesnt exist
Hi All!
I just posted a note about having problems creating temporary tables.
However, I JUST realized (and empirically verified) that my problem of not
being able to create temporary tables is that I didn't use an ID with the
CREATE permission enabled. I am a bonehead.
Thanks again!
Cheers!
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid
