title: MySQL: insert values from another table into one column
body: <p>I am wanting to move items from one table into another using MySQL.</p>
  <p>This is what I currently use:</p>
  <pre><code>INSERT INTO items_rooms (item_id, room_id,x,y,n)  
  SELECT id, room_id,x,y,z
    FROM `items_phoenix`
  </code></pre>
  <p>This works, however I am wanting to insert multiple values into one column instead of each values in different columns.</p>
  <p>For example:</p>
  <p>In table items_rooms, I would like values x and y from items_phoenix to be placed into one column in items_rooms.</p>
  <p>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?</p>
  <p>Sorry if this is confusing!</p>