mysql 一列加一列,MYSQL将另一张表中的值插入一列

I am wanting to move items from one table into another using mySQL.

This is what I currently use:

INSERT INTO items_rooms (item_id, room_id,x,y,n)

SELECT id, room_id,x,y,z

FROM `items_phoenix`

This works, however I am wanting to insert multiple values into one column instead of each values in different columns.

For example:

In table items_rooms, I would like values x and y from items_phoenix to be placed into one column in items_rooms.

If x = 5 and y = 2, can I save it into items_rooms like this: one column: 5.2 instead of different columns for each values?

Sorry if this is confusing!

解决方案

You can use expressions in your SELECT column-list. As long as the columns in the select-list and the columns in the destination table match in number and data type, you can do something like this:

INSERT INTO items_rooms (item_id, room_id, x_dot_y, n)

SELECT id, room_id, CONCAT(x,'.',y), z

FROM `items_phoenix`