Re: Problems with subquery and 'not in'

2004-02-26 Thread Victoria Reznichenko
Duncan Hill <[EMAIL PROTECTED]> wrote: > Mysql version: 4.1.1 > Platform: Linux, pre-compiled RPMs from mysql.com > > My problem: > Right now, I use a routine that selects the IDs that haven't been seen, and > promptly does an insert into notifications_seen to flag that it has been > seen. This

Re: Problems with subquery and 'not in'

2004-02-20 Thread Victoria Reznichenko
Duncan Hill <[EMAIL PROTECTED]> wrote: > Mysql version: 4.1.1 > Platform: Linux, pre-compiled RPMs from mysql.com > [skip] > > My problem: > Right now, I use a routine that selects the IDs that haven't been seen, and > promptly does an insert into notifications_seen to flag that it has been > s

Problems with subquery and 'not in'

2004-02-20 Thread Duncan Hill
Mysql version: 4.1.1 Platform: Linux, pre-compiled RPMs from mysql.com Table 1: CREATE TABLE `notifications` ( `recid` int(11) NOT NULL auto_increment, `recdate` datetime NOT NULL default '-00-00 00:00:00', `expiry` datetime default NULL, `notify_title` varchar(150) default NULL, `no