企业官网建设流程全解析

今天在执行 MySQL 插入数据时，发现报错了！

-- 生成 MySQL 初始化数据 INSERT INTO department(dept_id, dept_name) VALUES (1, '行政管理部'); INSERT INTO department(dept_id, dept_name) VALUES (2, '人力资源部'); ❌

报错

emp> INSERT INTO department(dept_id, dept_name) VALUES (2, '人力资源部') [2020-02-16 03:09:46] [HY000][1366] Incorrect string value: '\xE4\xBA\xBA\xE5\x8A\x9B...' for column 'dept_name' at row 1

由于MySQL默认编码格式latin1，而我要将utf8的中文插入数据库。

查看数据表的编码

showcreatetableemployee;

| employee | CREATE TABLE `employee` ( `emp_id` int(11) NOT NULL, `emp_name` varchar(50) NOT NULL, `sex` varchar(10) NOT NULL, `dept_id` int(11) NOT NULL, `manager` int(11) DEFAULT NULL, `hire_date` date NOT NULL, `job_id` int(11) NOT NULL, `salary` decimal(8,2) NOT NULL, `bonus` decimal(8,2) DEFAULT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`emp_id`), UNIQUE KEY `uk_emp_email` (`email`), KEY `idx_emp_name` (`emp_name`), KEY `idx_emp_dept` (`dept_id`), KEY `idx_emp_job` (`job_id`), KEY `idx_emp_manager` (`manager`), CONSTRAINT `fk_emp_dept` FOREIGN KEY (`dept_id`) REFERENCES `department` (`dept_id`), CONSTRAINT `fk_emp_job` FOREIGN KEY (`job_id`) REFERENCES `job` (`job_id`), CONSTRAINT `fk_emp_manager` FOREIGN KEY (`manager`) REFERENCES `employee` (`emp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

更改列的编码

altertableemp.department change dept_name dept_namevarchar(50)charactersetutf8;INSERTINTOdepartment(dept_id,dept_name)VALUES(2,'人力资源部')

插入数据成功