Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
[MYSQL TO JSON] Mysql data to json #mysql #to #json
select JSON_OBJECT
('id', id,
'user_login', user_login,
'user_pass', user_pass,
'user_nicename', user_nicename,
'user_email', user_email,
'user_url', user_url,
'user_registered', user_registered,
'user_activation_key', user_activation_key,
'user_status', user_status,
'display_name', display_name)
from wp_users INTO OUTFILE '/root/wp_users.json';
GRANT FILE ON *.* TO 'user'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.