MySQL Forums
Forum List  »  InnoDB

Re: dynamic outfile name
Posted by: KimSeong Loh
Date: August 14, 2007 02:16AM

Build the prepared statement by concatenating the user variable, no need the ? parameter

prepare s1 from concat('select * from ',@tablename);
execute s1

You should get the idea

Options: ReplyQuote


Subject
Views
Written By
Posted
9793
August 12, 2007 06:29PM
3181
August 13, 2007 05:24AM
3092
August 13, 2007 10:05PM
Re: dynamic outfile name
2986
August 14, 2007 02:16AM
3455
August 19, 2007 11:31AM
3278
August 19, 2007 06:46PM
3116
February 13, 2008 02:49PM
2483
February 14, 2008 04:45PM
2499
February 15, 2008 02:26PM
2435
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.