sql 更新表的某条数据的某列的内容

例如，计算方案的第一条的name修改为'消防-HFC',如下所示：

UPDATE calculation_templates
<span style="color:#dcc6e0">SET</span> algorithm_name = <span style="color:#abe338">&#39;消防-HFC&#39;</span>
<span style="color:#dcc6e0">WHERE</span> id = (
<span style="color:#dcc6e0">SELECT</span> id
<span style="color:#dcc6e0">FROM</span> calculation_templates
<span style="color:#dcc6e0">ORDER</span> <span style="color:#dcc6e0">BY</span> id
LIMIT <span style="color:#f5ab35">1</span>
);