Login Register

db\Migration batchInsert()

batchInsert() public method

Creates and executes an batch INSERT SQL statement.

The method will properly escape the column names, and bind the values to be inserted.

public void batchInsert ( $table, $columns, $rows )
$table	string	The table that new rows will be inserted into.
$columns	array	The column names.
$rows	array	The rows to be batch inserted into the table

Links:

http://www.yiiframework.com/doc-2.0/yii-db-migration.html#batchInsert()-detail

doc_Yii

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

mongodb\Migration batchInsert() batchInsert() public method Inserts several new rows into collection. public array batchInsert ( $collection, $rows, $options = [] )$collection

db\Migration $db $db public property The DB connection object or the application component ID of the DB connection that this migration should work with. Starting

db\Migration getDb() getDb() protected method (available since version 2.0.6) protected void getDb ( )

db\Migration execute() execute() public method Executes a SQL statement. This method executes the specified SQL statement using $db. public void execute ( $sql, $para

db\Migration dropTable() dropTable() public method Builds and executes a SQL statement for dropping a DB table. public void dropTable ( $table )$table string The table