Re: how to implement variable into string

[Scott Noyes]

Hi Krzysztof,

SET @sql := CONCAT("SELECT * INTO OUTFILE '/home/reports/security_", @a, "' FIELDS TERMINATED BY ...");
PREPARE myStmt FROM @sql;
EXECUTE myStmt;