Hi all!
I've got this piece of SELECT statement for MySql.
SELECT *
FROM messages
LEFT OUTER JOIN main
ON messages.topicid=main.topicid
WHERE main.topicid is null;
so the select statement works fine. But what I'd like to do is actually
delete those rows instead. but substituting SELECT with
Perl example kinda makes sense, I don't understand how to work it. Do I
just put that in a file and run open the file in a browser?
Thanks!
sunny
At 08:12 29/03/02 -0700, Rodney Broom wrote:
Good morning Sunny,
From: sunny [EMAIL PROTECTED]
...substituting SELECT with DELETE doesn't work
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
in Topics table, I want to
make sure there are no messages in the Messages table which have a topic_id
of 5.
Please please, any help would be greatly appreciated. I'm running MySQL
3.23.46 on UNIX.
TIA!
sunny
-
Before posting
with mysql-server-3.23.36-1
Please help! Thanks!
Sunny Ouyang
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Thank you very much for your help. I got it fixed with the command
'safe_mysqld--old-protocol ' Thank YOU!!!
-Original Message-
From: Nico D [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:44 AM
To: Simon Green
Cc: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: RE: emergency
whether what I did causes this problem. Now I can not connect to mysql when
I use mysql command. Please help me! All of our users rely on this
database. I would appreciate it if someone could give me help. Thank
you!!!
Sunny Ouyang
Orion System, Inc
525 Avis Dr.
Ann Arbor, MI 48108
(734)214
: Monday, June 04, 2001 9:52 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: RE: emergency help
Is mysqld runing?
Simon
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:56
To: '[EMAIL PROTECTED]'
Subject: emergency help
Hi,
I am seeking emergency help
Yes. All of our mysql databases are there.
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:28 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: Re: emergency help
I got the message:
[root@mothra /tmp]# safe_mysqld
[1] 3922
]]
Sent: Monday, June 04, 2001 10:14 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: Re: emergency help
Last Saturday when I rebooted Red Hat
Linux, mysql database server didn't come back any more.
Try typing this on the command line:
safe_mysqld
Then tell us what happens. :-)
L.A
Apache 1.3 API, this module might crash under
EAPI!
(please recompile it with -DEAPI)
-Original Message-
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:24 AM
To: Ouyang, Sunny
Subject: Re: using myodbc for mysql database on RedHat6.2
Sunny,
What errors do you
I found my '/tmp/mysql.sock' is also empty. Is this supposed to be empty?
my '/tmp/myscript' is empty, too. Are they correct?
-Original Message-
From: karel pitra [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:33 AM
To: Ouyang, Sunny
Subject: Re: emergency help
check
Message-
From: Rafal Jank [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:18 AM
To: Ouyang, Sunny
Cc: '[EMAIL PROTECTED]'
Subject: Re: emergency help
"Ouyang, Sunny" wrote:
Yes. All of our mysql databases are there.
Do you have error log file? It should be in /usr
13 matches
Mail list logo