Are you aware that you are using a nested sql query which isn't available until version 4.1?
Try splitting the delete into multiple steps 1) populate a temp table with the id's you want to delete then 2) use the temp table data to delete the rows. ----- Original Message ----- From: "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 > 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 ACCTSESSIONID = any (select ACCTSESSIONID from radiuslog > where ACCTSESSIONTIME='0'); > I can not delete the record by just deleting the record with the 0 ACCTSESSIONTIME > as this would only delete the Stop and not the > start record with the same ACCTSESSIONID from this radiuslog > http://netwinsite.com/dbabble/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
