ellens

摘要： #分页每页取指定条数记录 set @qq=concat('insert into tmp_tcicrm_oms_shipment(shipment_tid) select shipment_tid from tcicrm_oms_shipment_header where shipment_status = \'SHIPMENT_WAIT_CREATE\'limit ',@startLimit,@endLimit) ; PREPARE qq from @qq; EXECUTE qq;参数@startLimit指的是从第几天开始,@endLimit指的是取多少条记 阅读全文