postgres update delete 的使用

把name 是生产行业的calculation_plan修改为生产行业-0922

UPDATE calculation_plans
<span style="color:#dcc6e0">SET</span> name = <span style="color:#abe338">&#39;生产行业-0922&#39;</span>
<span style="color:#dcc6e0">WHERE</span> name = <span style="color:#abe338">&#39;生产行业&#39;</span>;

删除计算方案表的所有数据:

<span style="color:#dcc6e0">DELETE</span> <span style="color:#dcc6e0">FROM</span> calculation_plans;