L 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
rom: "tech" <[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
&g
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 ACCTSESSI
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 r
Hi,
I have a problem with nested delete query. I want to
delete some record from one table based on the select
result of another query. e.g.
delete from tab1 where uid in (select uid from tab2
where today >= 'any_date');
Will it work?
I tried, but it says that 'syntex error near
'select.'
