delete help

2003-12-07 Thread tech
I hope someone can help, I am a newbe as sql and need a some help I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0';| get a list that I then need to delete but when I used the following I keep get errors delete from radiuslog where

Re: delete help

2003-12-07 Thread Matthew
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:16 AM Subject: delete help I hope someone can help, I am a newbe as sql and need a some help I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0';| get a list that I

Re: delete help

2003-12-07 Thread tech
Subject: delete help I hope someone can help, I am a newbe as sql and need a some help I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0';| get a list that I then need to delete but when I used the following I keep get errors delete from

Re: Problem with nested delete - help

2001-08-20 Thread William R. Mussatto
On Sat, 18 Aug 2001, Ram wrote: Date: Sat, 18 Aug 2001 06:16:39 -0700 (PDT) From: Ram [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem with nested delete - help Hi, I have a problem with nested delete query. I want to delete some record from one table based on the select