CODEWITHSUNDEEP
mysql
Raj
Raj

Reputation: 11

Query about sql regarding export the results into excel

In this query i tried to export the result into csv... But i am getting error as

error:----Every derived table must have its own alias

SELECT * INTO OUTFILE "c:/mydata.csv"
FROM (SELECT e.server,e.token,e.datetime,e.workstation,f.surname,f.forename,f.token
FROM statistic e, USER f
WHERE e.token=f.token);

Upvotes: 0

Views: 289

Answers (1)

juergen d
juergen d

Reputation: 204854

Try defining an alias for your subselect:

SELECT * INTO OUTFILE "c:/mydata.csv" 
FROM (SELECT e.server,e.token as stat_token,e.datetime,e.workstation,
             f.surname,f.forename,f.token as user_token 
      FROM statistic e, 
      USER f 
      WHERE e.token=f.token) as server_statistics;

Upvotes: 1

Related Questions