I think I sorted it out ...
INSERT INTO master_comments (comment_no,comment_text,language_id)
SELECT comment_no,comment_text,language_id from mComments
WHERE NOT EXISTS
(
SELECT comment_no
FROM master_comments
WHERE mComments.comment_no = master_comments.comment_no
);
Hope this helps someone
Can anyone tell me why this isn't working... v5.0
INSERT INTO master_comments (comment_no,comment_text,language_id)
SELECT comment_no,comment_text,language_id from mComments
WHERE NOT EXISTS (SELECT comment_no FROM master_comments);
I thought I had it working once but now it
@lists.mysql.com
Subject: Re: WHERE (NOT) EXISTS problem
Michael Fischer wrote:
> Having a very bad time with the subject sorts of queries.
> Here is a simple reproduction of the problem for me.
> Perhaps I'm blind/stupid while looking at the docs,
> or there's a bug...
>
> m
PM
To: mysql@lists.mysql.com
Subject: WHERE (NOT) EXISTS problem
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
sim
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+--+--+-+
all class_name from classes that aren't
> represented a specific year.
>
> So what I want as result is HD, DD, MD
> I'm trying to use the following query:
>
> SELECT class_name FROM classes WHERE NOT EXISTS (SELECT * FROM champions
> WHERE champions.class_name=classes.
D, DD, MD
>
> I'm trying to use the following query:
>
>
> SELECT class_name FROM classes WHERE NOT EXISTS (SELECT * FROM champions WHERE
> champions.class_name=classes.class_name AND champions.year='1981')
>
>
> ERRORREPORT:
>
> #1064 - You have an
- Original Message -
From: "Carl Schéle, IT, Posten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 3:05 PM
Subject: WHERE NOT EXISTS
I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4
I have
)
1981 HS PETER
1981 DS ANNE
What I want to do is to list all class_name from classes that aren't represented a
specific year.
So what I want as result is HD, DD, MD
I'm trying to use the following query:
SELECT class_name FROM classes WHERE NOT EXIS
Jessica,
Monday, January 28, 2002, 3:13:11 PM, you wrote:
JR> Can anyone help me -
JR> I am trying to extract data on the availability of a holiday villa using the
JR> statement
JR> 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM
JR> Reservation WH
Can anyone help me -
I am trying to extract data on the availability of a holiday villa using the
statement
'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM
Reservation WHERE PossDate Between ArrDate And DeptDate AND
Reservation.VillaID=\'Adonis\')'.
12 matches
Mail list logo