BruceFeng

由于我表已经建好，并且插入了数据，无法用建表语句来添加索引，所以采用了添加索引的语句

1. mysql> CREATE INDEX employee_name on degree_employee (name);
   
2. Query OK, 0 rows affected (0.07 sec)
   
3. Records: 0  Duplicates: 0  Warnings: 0
   
4. 
   
5. mysql> CREATE TABLE degree_salary (SA_id INT AUTO_INCREMENT PRIMARY KEY,name varchar(10) NOT NULL ,salary DECIMAL(5,2) DEFAULT 0.0,FOREIGN KEY (name) REFERENCES degree_employee (name));
   
6. Query OK, 0 rows affected (0.06 sec)

复制代码

效果来看也解决了问题