程序员笔记

SELECT CONCAT('ALTER TABLE `',table_name,'` DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci;') FROM information_schema.TABLES WHERE table_schema = 'zabbix';
alter database zabbix character set utf8;