I am trying to write a query to dump a single LONGBLOB data into a file.
SELECT data FROM table WHERE id = 123 INTO DUMPFILE fileName
id are the fields in the table.
SQL syntax error near
fileName occurred when I try to run this query in HeidiSQL 10.2.0.
Does anyone know how to fix this error?
The database is MariaDB 5.5.
The following query works fine by the way:
SELECT data FROM table WHERE id = 123 INTO DUMPFILE 'data.pdf'