copy table data to excel through stored procedure.

Question

ID 

1

2

3

4

1

3

7 

 

how to copy every id related data to excel separately at a time by using stored procedures in sql server and mysql?

files names should be like id1_doc.csv, id2_doc.csv, etc  .