well i can do the select that way, but i was wondering how the following
delete command would only pick up the rows in the select. isn't there a way
of imbedding delete in the select statement?
can anyone else help as well please?
thanks
sunny
At 19:46 14/03/02 -0500, Jim Philips wrote:
To
To select the rows you are looking for, you can use:
select * from messages
left join topics on topics.topic_id=messages.topic_id
where topics.topic_id is null;
This works fine for selecting. But for some reason the corresponding SQL
for a delete fails:
mysql delete from messages
- left
Hi everyone,
I've got a really annoying problem with mysql, and I was hoping someone
could help.
I've got 2 tables in Mysql:
Table 1 - Topics
| topic_id | name | subject | comment |
-
| 1 | john | weather| the