Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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