Member-only story

How to export table in csv,text,json

Export table in csv file By Using mysql commands

Sanjay Singh
Sep 15, 2021

SHOW VARIABLES LIKE “secure_file_priv”;
SELECT * FROM bootapplication into outfile ‘/ProgramData/MySQL/MySQL Server 8.0/Uploads/mysql_processes.csv’;

Export table in csv file by using workbench

Step1-

Step 2-

Step 3-

Step 4 click next ->next finish

--

--

Sanjay Singh
Sanjay Singh

Written by Sanjay Singh

Java, Spring Boot & Microservices developer Sharing knowledge, tutorials & coding tips on my Medium page. Follow me for insights & see story list section

No responses yet