杞浇鑷狶aravel璁哄潧锛歨ttps://learnku.com/laravel/t...闅忕潃搴旂敤鐨勬墿灞曪紝浣跨敤LaravelEloquent澶勭悊澶ч噺鐨勬暟鎹簱璁板綍鍙兘鍙樺緱瓒婃潵瓒婂洶闅俱€傚鑷村唴瀛樹笉瓒冲紓甯革紝閫氬父浼氶檷浣庡簲鐢ㄧ▼搴忕殑閫熷害銆傝繖鏄负浠€涔堬紵浠庢暟鎹簱涓幏鍙栫粨鏋滄椂锛屾偍渚濇灏嗘暟鎹媺鍏ュ唴瀛樸€備互杩欐浠ｇ爜涓轰緥Post::all()->each(function($post){//...});杩欏皢瀵艰嚧浠ヤ笅鏌ヨ锛屽皢posts琛ㄤ腑鐨勬墍鏈夎褰曞姞杞藉埌鍐呭瓨涓璼elect*fromposts;閫氬父瀵逛簬璁板綍鏁拌緝灏戠殑琛紝杩欐槸缁濆鍙互鎺ュ彈鐨勩€備絾鏄紝褰撴偍绉疮浜嗘暟鍗冪瘒鏂囩珷鏃讹紝鎮ㄦ渶缁堝皢寮€濮嬭揪鍒癢eb鏈嶅姟鍣ㄧ殑鍐呭瓨璧勬簮闄愬埗銆傚垎鍧桳aravel涓殑涓€绉嶅父瑙佹柟娉曟槸浣跨敤Eloquent鐨勶紙閫氳繃BuildsQuery锛塩hunk()鏂规硶锛岃鏂规硶鑾峰彇鍥哄畾鏁伴噺鐨勮褰曪紝灏嗚緝澶х殑闆嗗悎鍒嗚В涓烘洿澶氬彲浣跨敤鐨勫潡銆侾ost::chunk(1000,function($post){//...});铏界劧杩欑湅璧锋潵涓嶉敊锛屼絾鏈夊緢澶氭敼杩涘拰娉ㄦ剰浜嬮」銆傞鍏堬紝鎯宠薄浠ヤ笅鍦烘櫙锛氭偍姝ｅ湪浠庢暟鎹簱涓幏鍙朠ost璁板綍浠ユ洿鏂皐here瀛愬彞涓篃浣跨敤鐨勫睘鎬ost::where('published_at','<',now())->chunk(1000,function($post){$post->update('published_at',now());});灏界浜轰负璁捐锛屼絾瀹冧妇渚嬭鏄庝簡涓€涓潪甯哥湡瀹炵殑闂锛屽嵆杩欐牱鐨勬煡璇細瀵艰嚧鏃犻檺寰幆锛屽洜涓哄湪涓嬩竴娆℃墽琛學henqueried鏃讹紝published_at灞炴€у皢濮嬬粓灏忎簬now()锛堝亣璁句娇鐢∕ySQL鐨勬椂闂存埑鍒楃被鍨嬬殑绮惧害涓虹鎴栫被浼硷級銆傚叾娆★紝瀛樺湪鏌ヨ鎬ц兘闂鍙婂叾瀵规暟鎹簱鏈嶅姟鍣ㄧ殑褰卞搷銆備笂闈㈢殑浠ｇ爜浼氫骇鐢熺被浼间笅闈㈢殑鏌ヨselect*frompostsorderbyposts.idasclimit1000offset9000鐢变簬鍒犻櫎璁板綍鍜岄澶栫殑鏌ヨ绾︽潫锛孧ySQL涓嶈兘鐩存帴鍘籵ffset锛屽洜姝わ紝杩欎釜鏌ヨ蹇呴』閫夋嫨绗竴涓?0,000鏉¤褰曟湁閫夋嫨鍦拌繑鍥炰粎閫夋嫨鐨勬渶鍚?,000鏉¤褰曘€傚彲浠ユ兂璞★紝杩欎笉鑳藉緢濂藉湴鎵╁睍鍒版暟鍗冭銆傝繖浼氬鑷存暟鎹簱鏈嶅姟鍣ㄤ娇鐢ㄤ笉蹇呰鐨勮祫婧愶紝浠庤€屽噺鎱㈠簲鐢ㄧ▼搴忎腑鐨勬墍鏈夊叾浠栨煡璇€傚ぇ鍧?.....浣嗘洿濂斤紒涓轰簡闃叉涓嶅彲棰勮鐨勯櫡闃卞苟鎻愰珮鏁版嵁搴撴湇鍔″櫒鎬ц兘锛屾垜浠彲浠ヤ娇鐢‥loquent鐨刢hunkById鏂规硶Post::where('published_at','<',now())->chunkById(1000,function($post){$post->鏇存柊锛?published_at'锛岀幇鍦紙锛夛級;}锛?涓婇潰鐨勪唬鐮佺墖娈靛皢浜х敓绫讳技浜庝互涓嬬殑鏌ヨselect*frompostswherepublished_at<'2019-09-1112:00:00'andid>9000orderbyidasclimit1000涓轰粈涔堣繖绉嶆柟娉曡璁や负鈥滄洿濂解€濓紵a)瀹冨厑璁窶ySQL瀹屽叏璺宠繃鍓?000鏉¤褰曪紙鍋囪鏄『搴忚褰曪級b)鐢变簬where瀛愬彞涓殑id绾︽潫锛屾垜浠皢涓嶅啀閲嶆柊閫夋嫨宸茬粡鏇存柊鐨勮褰曞鍔?鎬庝箞鏍凤紵锛侌煠旀繁鍏ョ爺绌禕uildsQueries鐗规€hunkyById鏂规硶鎴戜滑[see](https://github.com/laravel/fr...瀛樺偍鏈€鍚庝竴鏉¤褰曠殑ID锛堣浣忥紝鎴戜滑鎸塈D鍗囧簭鎺掑簭锛夎瀛樺偍鍜屼笅涓€鏉¤褰時un鍦ㄦ煡璇腑浣滀负鍙傛暟浣跨敤锛岃璁鸿鍒颁笓涓氱殑Laravel璁哄潧锛歨ttps://learnku.com/laravel/t...
