NIUCLOUD是一款SaaS管理后台框架多应用插件+云编译。上千名开发者、服务商正在积极拥抱开发者生态。欢迎开发者们免费入驻。一起助力发展！ 广告
连表更新某个字段的值 ``` UPDATE tableA AS a LEFT JOIN tableB AS b ON a.orderid = b.orderid SET a.settlementtype = 7 WHERE b.paytype = 'keepsettle'; UPDATE jilisi_statistics_order_detail AS st LEFT JOIN jilisi_order AS o ON st.orderid = o.orderid SET st.settlementtype = 7 WHERE o.paytype = 'keepsettle'; ```