Member-only story
How to export table in csv,text,json
Export table in csv file By Using mysql commands
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