draev/MySQL Import json data

Created April 26, 2019 12:36

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/draev/88211d8ae37e11686991374a1e1689a5.js"></script>
Save draev/88211d8ae37e11686991374a1e1689a5 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

MySQL Import json data

sed -E "s/(X'[^,\)]*')/CONVERT(\1 using utf8mb4)/g" infile.sql > outfile.sql

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