How to export table in csv,text,json

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

Step1-

Step 2-

Step 3-

Step 4 click next ->next finish

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Customer-Centric Cloud Hosting Company

AkitaVerse — A Metaverse for Dogs

InfoSec Are Our Friends, Not food

Security button in a web browser with mouse cursor over the letter S

Smart Machine Vision Software

How to Successfully Set Tasks and Boost Your Development Team’s Productivity

Azure Data Services and Microsoft’s Common Data Model

Coding Standard in Java

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sanjay Singh

Sanjay Singh

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

More from Medium

Regular Expressions (RegEx)

Migrate Postman Tests to Insomnia Step by Step guide

How to Remove HTML Tags <p> from your Data

How To Use JavaScript Wait Function In Selenium WebDriver