Re: Why does my delete not work :(

s so while your 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]> &g

Why does my delete not work :(

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 DE

Re: Please help - About doing a delete.

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

Please help! - About doing a delete.

with topic_id 5 was deleted 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 -

Mysql -server conflicts error

licts 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 t

RE: emergency help

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]'

RE: emergency help

k'. Restart using --o ld-protocol mysqld ended on Mon Jun 4 10:27:29 EDT 2001 [root@mothra var]# -Original 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 &q

RE: emergency help

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: em

RE: emergency help

plain 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 d

RE: emergency help

CTED]] 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 t

RE: 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]# sa

RE: emergency help

o:[EMAIL PROTECTED]] Sent: 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

x27;t know 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 4810