copy data to folder with csv file

Question

Hi,

 

id

1

2

3

4

 

Where every id  will be having lakhs of data, how to move each id related data to excel in through stored procedure at a time?

 

usually i can do like exec procedure(id)  manually.

 

how can i acheive it in mysql and sql server.