t; <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 06, 2003 2:29 am
Subject: Re: [PHP-DB] Create Temporary Table
> Does the ip address of where you are trying to access the mysql database
>
7;t changed, and I have CREATE TEMPORARY
TABLE rights.
Any ideas why this is intermittent?
Thanks for your help!
Phil Dowson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Very good question, I believe I do since it does work 90% of the time. Only
occasionally it doesnt work, and thats why I need help
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&
m trying to use the database either from the localhost or from a remote
IP and have the same problem. I have plenty of disk space allocated to me.
The version of MySQL is 4.013, it is running on a Linux OS Kernel version
2.4.20-18.7, I am pretty sure its Redhat 7.2, I can find out if its
relevant.
Sorry the problem fixed itself, and I mistakenly sent this email
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 9:01 am
Subject: Re: CREATE T
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Quoting Bruce Feist <[EMAIL PROTECTED]>:
> Phil Dowson wrote:
>
> >SELECT t1.t1id
> >FROM t1
> >LEFT JOIN t2 ON t1.t1id = t2.t2id
> >WHERE t2.t2gid <> 192 //an example of a gid I am using//
> >
> >This is close, it shows all the id
Quoting Bruce Feist <[EMAIL PROTECTED]>:
> Phil Dowson wrote:
>
> >>Looks like a syntax error to me. There is no t1id in t2. Also, the OR
> >>is redundant; if no t2 row was found, both t2id and t2gid will be NULL,
> >>so checking one of them suffices.
hich should only show:
t1
't1id'
'18'
and so far the best I can come up with is:
SELECT t1.t1id FROM t1 LEFT JOIN t2 ON t1.t1id=t2.t1id WHERE t2.t1id
IS NULL OR t2.t2gid IS NULL
But this shows no results
TIA
Phil Dowson
-
