Write Mysql output to file

This is what i use to write the SQL output to a filedrive:

SELECT 1 FROM DUAL INTO OUTFILE '\\\\\192.168.0.13\\Divers\\demo.sql';

Note: you can write only once like this, otherwise you get message that the file exists. :-)

 

This example shows how to create dynamic name:

CREATE PROCEDURE export_dynamic(IN file_name CHAR(64))
BEGIN
SET @myvar = CONCAT('SELECT * INTO OUTFILE ',"'",file_name,"'",' FROM Table1') ;
PREPARE stmt1 FROM @myvar;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END;