MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: PREPARE STM1 syntax error
Posted by: Jose Perez
Date: April 14, 2017 01:17PM

Hello,

When I run the SELECT @query, now renamed as @myCommand, on MySQL Workbench, I see this on the result grid:

FieldName:
@myCommand := concat("SELECT * FROM test.station07 INTO OUTFILE 'c:/logs/test/", DATE_FORMAT(now(), '%Y_%M_%D'),".csv' FIELDS TERMINATED BY ',' ENCLOSED BY '""' ESCAPED BY '\\'LINES TERMINATED BY '\n'")
ROW:
'SELECT * FROM test.station07 INTO OUTFILE \'c:/logs/test/2017_April_14th.csv\' FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' ESCAPED BY \'\\\'LINES TERMINATED BY \'\n\''

Sorry that I can't seem to share this in the form of a screenshot, but hopefully you can understand how the results look like.

Options: ReplyQuote


Subject
Views
Written By
Posted
480
April 14, 2017 09:04AM
275
April 14, 2017 10:24AM
226
April 14, 2017 10:45AM
Re: PREPARE STM1 syntax error
292
April 14, 2017 01:17PM
239
April 14, 2017 02:13PM


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.