rement not null
...other data
I'd like to delete all of the records from Table Two which have an id
that is not found in Table One.
I could do it programatically in C or PHP or ... but is there some
kind of SQL statement than can do the job?
Thanks,
Bill
--
Bill Rausch, Software E
2190 www.toll.com.au
_
| -Original Message-
| From: Bill Rausch [mailto:[EMAIL PROTECTED]]
| Sent: Tuesday, 17 December 2002 11:52 AM
| To: [EMAIL PROTECTED]
| Subject: mailing list problem?
|
|
| I just got a message fro
I just got a message from the ezmlm program telling me that the
mysql digests have been bouncing and it is going to remove me from the list.
In fact, the digests have been coming through just fine. Any ideas
on what it could be referring to? Did anyone else get such a message?
Bill
--
Bill
474 Jun 17 13:04 naif.err
-rw-rw1 mysqlmysql 3 Jun 17 13:04 naif.pid
drwx--2 mysqlmysql4096 Apr 19 11:13 test
--
Bill Rausch, Software Development, UNIX, Mac, Windows
Numerical Applications, Richland, WA 50
;1 row in set (59.56 sec)
>
>mysql> select count(distinct m0.doc_id) from main_index as m0,
>main_index as m1, main_index as m2 where m0.word_id=10 and
>m1.word_id=2327 and m2.word_id=9 and m0.doc_id=m1.doc_id and
>m0.doc_id=m2.doc_id;
>+---+
>| count(distinct m0.doc_id) |
>+--
rticular query.
> > It fails on two different platforms (Linux and Mac OS X).
>>
--
Bill Rausch, Software Development, UNIX, Mac, Windows
Numerical Applications, Richland, WA 509-943-0861
-
Before posting, plea
ied calling mysql_real_query directly but that didn't fix anything.
Bill
--
Bill Rausch, Software Development, UNIX, Mac, Windows
Numerical Applications, Richland, WA 509-943-0861
-
Before posting, please check:
http://www
