mysql命令行插入乱码

-- 查看当前数据库字符集
SHOW CREATE DATABASE your_database_name;

-- 修改数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 查看当前表字符集
SHOW CREATE TABLE your_table_name;

-- 修改表字符集
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

SET NAMES 'utf8mb4';

-- 创建表并设置字符集
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 插入数据
INSERT INTO users (name) VALUES ('张三');

-- 查询数据
SELECT * FROM users;