Yii2 activerecord bulk insert

Activerecord batch insert in yii2

Yii::$app->db
->createCommand()
->batchInsert('table_name', ['column1','column2', 'column3','column4','column5'],$data)
->execute();

Source: devprofessor.com

Yii2 activerecord bulk insert

// It's usually much easier to use DAO instead of ActiveRecord

// table name, column names, column values
Yii::$app->db->createCommand()->batchInsert('users', ['name', 'age'], [
    ['Tom', 30],
    ['Jane', 20],
    ['Linda', 25],
])->execute();

Source: yiiframework.com

Similar codes

0 vote125 views1 answer
Snactum laravel
PHP Laravel
0 vote128 views2 answers
Laravel sortby varchar date
PHP Laravel
10 votes108 views2 answers
ForeignId in laravel
PHP
82 votes122 views6 answers
Php float to int
PHP
0 vote141 views1 answer
Woocommerce product image zoom on hover disable
PHP
0 vote107 views1 answer
Laravel weekly data
PHP
19 votes102 views4 answers
Remove first letter php
PHP
11 votes126 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP
3 votes111 views2 answers
Error: Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
0 vote120 views1 answer
Fallo al conectar al servidor ftp wordpress
PHP Wordpress