mysql两个表有同一字段_mysql 连接两个表为一个表 两个表中有两个字段相同的要合并...

把表结构交待下吧：t1：name,body+---------------------+----------+|name|desc|+---------------------+----------+|STR_SWORD_CIRCULOUS|性感泳装||STR_GOBLIN_PICK|游泳镜|+-----...

把表结构交待下吧：

t1 ：name,body

+---------------------+----------+

| name | desc |

+---------------------+----------+

| STR_SWORD_CIRCULOUS | 性感泳装 |

| STR_GOBLIN_PICK | 游泳镜 |

+---------------------+----------+

t2 ：id,desc

+-----------+---------------------+

| id | desc |

+-----------+---------------------+

| 100000001 | STR_SWORD_CIRCULOUS |

| 100000002 | STR_GOBLIN_PICK |

+-----------+---------------------+

现在问题是：name 和 desc 的值其实是相同的！

我希望得到的新表为这样的：

t3 :id,desc,name

+-----------+---------------------+---------+

| id | desc | name |

+-----------+---------------------+---------+

| 100000001 | STR_SWORD_CIRCULOUS | 性感泳装|

| 100000002 | STR_GOBLIN_PICK | 游泳镜 |

+-----------+---------------------+---------+

展开