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