mysql - 关于 Laravel4 中的重复键更新查询

Question

我如何转换它

DB::table('partners')->insert(array($data));

laravel 查询 ON DUPLICATE KEY UPDATE

结构看起来像

$data['program_name'] = $program['program']['_'];
$data['program_id'] = $program_id;
$data['status'] = $program['status'];
$data['shop_name'] = $shop->name;
$data['shop_logo'] = $shop->image;
$data['shop_description'] = $shop->description;

program_id 是唯一的

Answer 1

使用类似这样的东西(随意更正，因为它未经测试):

DB::statement( 'INSERT INTO partners VALUES (' . implode( ',',
    array_map( function( $val ) { return ":$val"; } , array_keys($data) )
) . ') ON DUPLICATE KEY UPDATE ' . implode( ',',
    array_map( function( $val ) { return "$val = VALUES($val)"; } , array_keys($data) )
), $data);