This code work as send to "inn_db" table from "ext_db".
but it was not checked if the data is the same or different in inn_db. So there posited same values in "inn_db". How could I add that job? Thanks.
In Laravel-5.4, MySQL, InnoDB.
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use \DB;
class UpdateCustomerController extends Controller
{
public function db_update()
{
$customers = \DB::connection('ext_db')->table('customers')->orderBy('customer_id')->chunk(1000, function ($all){
foreach ($all as $kunde){
DB::connection('inn_db')->table('custoemrs')->insert(
[$kunde->customer_id
$kunde->name,
$kunde->email]);
}
});
}
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire