MySql UPDATE

UPDATE 修改資料表中的資料

UPDATE table_name
SET column1=value1, column2=value2, column3=value3···
WHERE some_column=some_value;

WHERE 條件式

UPDATE `customers`
SET Name="Lara", Address="zzz路29號", Phone="0910-123456",City="台中市"
WHERE C_Id=5;