yarastqt · March 20, 2017 13:49
diff --git a/changeDBEncode.sql b/changeDBEncode.sql
 SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as sqlcode
    FROM `information_schema`.`TABLES` t
 WHERE 1
    AND t.`TABLE_SCHEMA` = 'db_name'
 ORDER BY 1
	SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as sqlcode
	FROM `information_schema`.`TABLES` t
	WHERE 1
	AND t.`TABLE_SCHEMA` = 'db_name'
	ORDER BY 1