Convert any SQL Table to CSV or JSON file formats (using MySQL Workbench)

This video is on "How to Convert any SQL table to a Comma Separated Values format (.csv) or JavaScript Object Notation format (.json)".
I'm using MySQL Workbench for this purpose. You can use any SQL Server for this.
Convert to JSON :- 01:59
Convert to CSV :- 02:35
Install MySQL on Computer :- • How to install MySQL t...
Install SQL on Android :- • How to run SQL queries...
SQL Tutorial :- • Basic SQL tutorial for...
Background Music used:-
Higher by Roa / roa_music1031
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/higher-roa
Music promoted by Audio Library • Higher - Roa (No Copyr...
#json #csv #sql #table #convert

[@ajaybhati21]

Watched your all vedios brother... learnt a lot..i am starting my career in tech... thanks...keep rocking..all the best for your future..

[@EverythingComputerized]

Thanks and all the best buddy♥️

[@ajaybhati21]

@@EverythingComputerized oh man are you still awake...

[@EverythingComputerized]

Yeah!

[@anam5381]

Watched all your video. It was the best of explanation.

[@EverythingComputerized]

Glad to hear that🙂

[@amitwaghmare23]

Thank you so much

[@EverythingComputerized]

😊🙌

[@ksailaja8804]

Your videos are wonderful shall plz make the full course of sql and plsql

[@EverythingComputerized]

Due to some reasons, I've paused the tutorial, but I'll surely resume it as soon as possible!
I really appreciate your support!

[@akshaypatil8155]

whatever datatype and constraints we write while creating columns for a table in mysql, after exporting it into csv, will the datatype and constraint remains or they disappear? i mean in csv for example in name column instead of varchar format, if i input integer will the csv file throw error?

[@EverythingComputerized]

It doesn't giveb any information about the data types.
But the integer value are stored as plain numbers, varchars are stored as strings.

[@akshaypatil8155]

what is the flow of operations? first we create a table in mysql, then we export it in csv format. from here where does the csv file is stored and how a users data is saved in this csv whenever a user inputs his/her inofrmation on a website. Can you please talk about the entire flow of creating a table untill how a users data is stored in the csv? The complete journey. Please reply asap, or atleast tell me what should i search on the internet to get this information?????????????????????????

[@EverythingComputerized]

A Google search would be a quick solution to your problem, coz I'll also have to do the same!

[@krutikapoojary2802]

how to change the database format to JSON in MySQL Workbench?

[@EverythingComputerized]

Table can only be converted.
Database conversion is possible in phpmyadmin

[@krutikapoojary2802]

Everything Computerized
Oh thank you

[@EverythingComputerized]

❤