MySQL Forums
Forum List  »  InnoDB

Re: dynamic outfile name
Posted by: David Harris
Date: August 13, 2007 10:05PM

Thanks for your suggestion.

I am still missing something. The code continues to show an error.

This is how I coded for the PREPARE statement.
----------------------------------------------
SELECT @sync:=concat(CURDATE(),CURTIME());

PREPARE stmt_name FROM "SELECT * INTO OUTFILE ?
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM marcupdate";

SET @marcFile = CONCAT('c:/scripts/marcUpdate', @sync,'.txt');

EXECUTE stmt_name USING @marcFile;

DEALLOCATE PREPARE stmt_name;
------------------------------------------------

I'm open for suggestions.

Best Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
10478
August 12, 2007 06:29PM
3373
August 13, 2007 05:24AM
Re: dynamic outfile name
3410
August 13, 2007 10:05PM
3241
August 14, 2007 02:16AM
3767
August 19, 2007 11:31AM
3525
August 19, 2007 06:46PM
3419
February 13, 2008 02:49PM
2748
February 14, 2008 04:45PM
2715
February 15, 2008 02:26PM
2577
February 20, 2008 04:12AM


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.