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
442
April 14, 2017 09:04AM
245
April 14, 2017 10:24AM
205
April 14, 2017 10:45AM
Re: PREPARE STM1 syntax error
266
April 14, 2017 01:17PM
215
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.