表一:
mysql> select * from employee;
+----+--------+---------+
| id | name | manager |
+----+--------+---------+
| 1 | 张三 | 李红 |
| 2 | 张三 | 李红 |
| 3 | 王五 | 刘倩 |
| 4 | 马六 | 马芳 |
| 5 | 孙杨 | 明德 |
| 6 | 郭德纲 | 华北 |
+----+--------+---------+
表二:
表二的数据填充有所不同,如下:
sql:insert into manager(name) select manager from employee group by manager;
mysql> select * from manager;
+----+------+
| id | name |
+----+------+
| 1 | 刘倩 |
| 2 | 华北 |
| 3 | 明德 |
| 4 | 李红 |
| 5 | 马芳 |
+----+------+
如何把两张表连接起来?并且将employee表里面的manager存储的数据变为manager表的id?
sql: update employee as e inner join manager as m on e.manager=m.name set e.m