-- 删除数据delete from meta_order_items where meta_order_items_id in( select b.meta_order_items_id from ( -- 主意：同一张表要外包这一层视图 select meta_order_items_id from meta_order_items where state='create' and CREATED_STAMP <'2015-11-19' ) b)
本文共 335 字，大约阅读时间需要 1 分钟。
-- 删除数据delete from meta_order_items where meta_order_items_id in( select b.meta_order_items_id from ( -- 主意：同一张表要外包这一层视图 select meta_order_items_id from meta_order_items where state='create' and CREATED_STAMP <'2015-11-19' ) b)
转载于:https://my.oschina.net/moks/blog/532885