How to export table in csv,text,json

Sanjay Singh
Sep 15, 2021

Export table in csv file By Using mysql command

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

Java||Spring-Boot|| Micro services Application developer|| INDIA