deyvicode/exporttojson.sql

Last active January 5, 2022 03:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/deyvicode/36a85531318be2c2f03f4ee764993597.js"></script>
Save deyvicode/36a85531318be2c2f03f4ee764993597 to your computer and use it in GitHub Desktop.

Download ZIP

Export JSON file from SQL database

Raw

exporttojson.sql

	SELECT JSON_ARRAYAGG(JSON_OBJECT(
	'name', name,
	'address', address
	))
	FROM mybd.mytable
	INTO OUTFILE '\path\users.json';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment