Exporting download list

[arco]

This is not directly a jDownloads issue, but related. (hope somebody knows what's going on)

I try to create a list of downloads by doing an SQL query.
This works fine on screen, but fails if I add INTO OUTFILE, and I don't understand why...
(according to the manual this should work:


[gelöscht durch Administrator]

[Arno]

Hi,
I think you should try it in a MySQL forum.
I have never use this. 

[Stefan1200]

Wie man hier sehen kann, ist deine SQL Syntax falsch:
https://dev.mysql.com/doc/refman/8.0/en/select-into.html

Die INTO OUTFILE Anweisung muss vor FROM. Also vermutlich so:
SELECT file_id,file_title,url_download,size INTO OUTFILE 'test.csv' FROM jmdnx_jdownloads_files