This is not possible in MySql.. but you have an alternative to this.. try using Concat function.. like..
SET @sql= CONCAT("SELECT * FROM table t1 INTO OUTFILE /my_path/", myvar,".txt"); PREPARE stmt FROM @sql; EXECUTE stmt;
You should store the row/ field value in myvar and pass it using CONCAT function.
edit | flag
Gokul A Answered on: Jul 25, 2011 at 8:16PM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!