How to run Multiple Queries and result store in multiple csv files

Vote count:

-1

how to run mysql query and output the results in csv. i know the solution should be like this:

SELECT col1,col2,col3
 FROM my_table
 INTO OUTFILE '/tmp/orders.csv'
 FIELDS TERMINATED BY ','
 ENCLOSED BY '"'
 LINES TERMINATED BY '\n';

But my problem is,i have approx 15 queries and i want to run all 15 query and results store in multiple csv files.currently for first query it's working fine and create the csv file.but not creates the csv for other queries.Please Help :)

asked 2 mins ago

Priyank

1,064

How to run Multiple Queries and result store in multiple csv files