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.

Subscription-Based Smart Contract

Clean Code — Introduction

The Azure Well-Architected Framework

CS373 Fall 2021: Ian Winson

Docker Tips: Check Your Docker Security in Two Steps

DevSecOps Tips: Audit Docker Security

Raspberry pi development setup on Eclipse [Linux] and Debugging via SSH

Ubuntu tips and tricks: Configuring multiple gcc in same Ubuntu machine

From Flask, Gunicorn, Nginx to Docker and Security through HTTPS and Client Certificate

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

Using the CASE Statement in SQL Server

Problem(Prepare-SQLAdvanced Select-Occupations)

SQL 총 복습

Internship at Mirra Healthcare