Extending yii\db\Command

Yii 2.0 General Discussions
1

Hello,

I saw this piece of code online and presume it is for Yii(1). How could I do this in Yii2?

In essence, I would like to add the "ON DUPLICATE KEY UPDATE" command to the Yii batchInsert() function.

Many thanks


class MyQueryBuilder extends yii\db\mysql\QueryBuilder

{

    public function batchInsert($table, $columns, $rows)

    {

        $sql = parent::batchInsert($table, $columns, $rows);

        $sql .= 'ON DUPLICATE KEY UPDATE';

        return $sql;

    }

}