我的MySQL表 struct 如下:
+----------------+----------------+----------+
| zipcode | city | state |
+----------------+----------------+----------+
| 10954 | Nanuet | NY |
+----------------+----------------+----------+
我想将上述三列合并为一列,如下所示:
+---------------------+
| combined |
+---------------------+
| 10954 - Nanuet, NY |
+---------------------+
我想把这个"组合"列添加到表的末尾,而不 destruct 原来的3个字段.