导航菜单
首页 >  文章

分类:文章

How to easily convert utf8 tables to utf8mb4 in MySQL 55

Database Administrators Stack Exchangehttps://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables …How to easily convert utf8 tables to utf8mb4 in MySQL 5.52011年11月22日 · This solution will generate and then run queries needed to convert databases, tables and columns. It converts all columns of the type varchar, text, tinytext, mediumtext, longtext, char.. You should always backup your database in case something goes wrong.. Copy the following query into gen_queries.sql, replacing the 4 occurrences of …