sql查询从table1中选择id并更新到table2

Question

I have two tables ok

  hawker_master table
  id   hawker_name
  1     raj
  2     vicky

  customer_entry table
  hawkername
   raj
   raj
   vicky

I need sql query which select id of particular hawker_name from hawkermaster and update id in place of hawkername in customer_entry table like below ex..

FOR EX -

  customer_entry table
  hawkername
   1
   1
   2

Answer 1

You can use the multi-table UPDATE syntax to perform a join:

UPDATE customer_entry ce
  JOIN hawker_master  hm ON hm.hawker_name = ce.hawkername
SET    ce.hawkername = hm.id