The alternative query is there because if it fails to update the record (lets say the start record never got logged) then it inserts a whole new record with both a start and a stop. ________________________________ From: freeradius-users-bounces+john.mylchreest=ioko.com@lists.freeradius.org [mailto:freeradius-users-bounces+john.mylchreest=ioko.com@lists.freeradius.org] On Behalf Of ravi reddy Sent: 27 July 2006 09:02 To: freeradius-users@lists.freeradius.org Subject: Mysql--just clarification Hi Users I am using Freeradius-1.1.2 with mysql database: In sql.conf i found these following accounting_stop_query and accounting_stop_query_alt one have update querie and the later have the insert query this is became a lots confusion to me.. can any body please explain me why these two i think only one is enough just update any suggestions please:-) Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes. Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it has been sent. If you have reason to believe that you are not the intended recipient of this communication, please contact the sender immediately. No employee is authorised to conclude any binding agreement on behalf of ioko with another party by e-mail without prior express written confirmation. ioko365 Ltd. VAT reg 656 2443 31. Reg no 3048367. All rights reserved.