将数据库所有的表的字符集改为utf8

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