mysql怎么变成中文

ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE your_table_name MODIFY your_column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

mysql -u your_username -p --default-character-set=utf8mb4

import mysql.connector

config = {
  'user': 'your_username',
  'password': 'your_password',
  'host': '127.0.0.1',
  'database': 'your_database_name',
  'charset': 'utf8mb4'
}

cnx = mysql.connector.connect(**config)

mysql -u your_username -p --default-character-set=utf8mb4 your_database_name < your_data_file.sql

mysqldump -u your_username -p --default-character-set=utf8mb4 your_database_name > your_data_file.sql