Advertisement
Guest User

Untitled

a guest
Feb 18th, 2017
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. mysql --user=db_user --password='db_pass' --database=db_name -B -N -e "SHOW TABLES" | awk '{print "SET SESSION sql_mode='NO_ENGINE_SUBSTITUTION';", "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' | mysql --user=db_user --password='db_pass' --database=db_name &
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement