cannot get SELECT INTO FILE to work

[duncanusher]

MYsql Script
I am trying to output a concatuating file for results in a querie, if I am right the script below is actually known as a injection query and i am unable to get it to work

          UPDATE ${acct_table2} SET \
             AcctStopTime       = '%S', \
             AcctSessionTime    = '%{Acct-Session-Time}', \
             AcctInputOctets    = '%{Acct-Input-Gigawords:-0}' << 32 | \
                                  '%{Acct-Input-Octets:-0}', \
             AcctOutputOctets   = '%{Acct-Output-Gigawords:-0}' << 32 | \
                                  '%{Acct-Output-Octets:-0}', \
             AcctTerminateCause = '%{Acct-Terminate-Cause}', \
             AcctStopDelay      = '%{Acct-Delay-Time:-0}', \
             ConnectInfo_stop   = '%{Connect-Info}' \
          WHERE AcctSessionId   = '%{Acct-Session-Id}' \
          AND UserName          = '%{SQL-User-Name}' \
          AND NASIPAddress      = '%{NAS-IP-Address}' \
 
           #everything works till this point but then the following doesn't work
           SELECT AcctSessionId, AcctUniqueId, UserName \
                 INTO FILE '/reports/' & '%{Acct-Unique-Session-Id}' & '.CSV' \
                 FIELDS TERMINATED BY ',' OPTIONALLY \
                 ENCLOSED BY '"' \
                 LINES TERMINATED BY '\n' \
                 FROM acct_table1"
 

[Atli]

Hi Duncan.

Please use [code] tags when posting code.

These look like two separate queries. A UPDATE query and a SELECT query.
Have you tried running them separately?

The SELECT query also seems to be missing a FROM clause.

[duncanusher]

Hi Duncan.

Please use [code] tags when posting code.

These look like two separate queries. A UPDATE query and a SELECT query.
Have you tried running them separately?

The SELECT query also seems to be missing a FROM clause.

the problem is that i need a script to send a single record to a single csv file to a report directory everytime that a record is completed and this is done once a account stop signal is recieved, this ativates the code i have put in.

[Atli]

If your only goal is to add to a CSV file after you update, why don't you use whichever programming language you are using to execute the query to add this to the file?
Or is there any specific reason why you want this to be done through MySQL?

[bartonc]

#
SELECT AcctSessionId, AcctUniqueId, UserName
     INTO OUTFILE '/reports/'

[duncanusher]

My problem is this works on a radius server and when someone disconnects i need to send my record to my sql accounting server and therefore i have to have a csv to import but i need a new file for each completed record, the stop command is proxied to me so that is why I cannot change the program, maybe I must explain a bit further in what the program does.

It has a start record "tells me where the user is in the world and then creates a unique session id, and a start time.

Then there is multiple update queries sent to the server which up date the record for that session with data usage and time usage.

When the user logs out it then runs a stop query which ends the session at this time I want just the completed record sent to a csv file that is stored on my accounting server and is proccessed, the whole system needs to be a live system as some users may be prepaid.

If I had my way I would just do the whole accounting proccess on my linux fedora server but we are integrating into a windows server 2003 with a accounting package written spicifically for the rest of our business in SQL 2005.