title: Replace data in MySQL table with data from another table
body: <p>I am trying to modify an existing MySQL database for use in a new application.
  I have a table of items (table_items), which has multiple fields, including "ItemID" and "ItemName".
  I have another table (table_list) which has "ItemName" in it, but no ItemID. I need to either update this table to contain ItemID instead of ItemName, or create a new table which imports ItemIDs from table_items as opposed to the ItemName when table_list.ItemName = table_items.ItemName.</p>
  
  <p>I have tried the following:
  UPDATE table_list A, table_items B 
  SET A.ItemName = B.ItemID 
  WHERE A.ItemName = B.ItemName</p>
  
  <p>The current table has over 500,000 rows and every time i try this in PHPMyAdmin i get the error "the MySQl server has gone away".</p>
  
  <p>Any help greatly appreciated.</p>