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 vote205 views1 answer
Php foreach random
PHP
0 vote184 views1 answer
Get lat long from google maps php
PHP
2 votes230 views2 answers
Laravel get file in public folder
PHP Laravel
96 votes222 views6 answers
Strpos in php
PHP
0 vote189 views1 answer
Twig request
PHP
1 vote186 views2 answers
Laravel get query output
PHP
4 votes216 views2 answers
Laravel collection count
PHP Laravel
1 vote232 views1 answer
Laravel start que listener
PHP Laravel
4 votes188 views1 answer
PHP artisan create model and seeder shortcut
PHP
-1 vote174 views1 answer
Laravel image upload permission denied
PHP