Skip to content

Instantly share code, notes, and snippets.

@wujiyu115

wujiyu115/mysql_charset.sql

Created August 21, 2017 03:33
Show Gist options
  • Save wujiyu115/23b09a96c49f5b87b9ecef47665f9134 to your computer and use it in GitHub Desktop.
Save wujiyu115/23b09a96c49f5b87b9ecef47665f9134 to your computer and use it in GitHub Desktop.
Download ZIP
mysql_charset
Raw
mysql_charset.sql
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4;') AS mySQL
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA= "chess_log"
AND TABLE_TYPE="BASE TABLE"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment