MySQL Forums
Forum List  »  MySQL Workbench

Re: how to implement variable into string
Posted by: Scott Noyes
Date: July 16, 2008 08:51AM

Hi Krzysztof,

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to implement variable into string
2525
July 16, 2008 08:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.