mysql起中文别名

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    course_id INT
);

CREATE TABLE courses (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

SELECT s.name AS student_name, c.name AS course_name
FROM students s
JOIN courses c ON s.course_id = c.id;

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;

import mysql.connector

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

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