UPDATE mw_shop_setting a, mw_shop_setting_lock b SET a.key_val = b.week_day WHERE substr(a.key_name,19)=b.building_id AND substr(key_name,1,18)='buliding_week_day_' AND a.shop_id=28;
复杂的sql语句
最新推荐文章于 2023-05-22 11:48:49 发布
UPDATE mw_shop_setting a, mw_shop_setting_lock b SET a.key_val = b.week_day WHERE substr(a.key_name,19)=b.building_id AND substr(key_name,1,18)='buliding_week_day_' AND a.shop_id=28;