How to export table in csv,text,json
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