insert,update or delete multiple rows in one sql query

with this extension you can insert,update or delete multiple rows of your tables just in one sql query.

In this way you can make insertions,updates or deletes records into the tables with best performance and secure using sql statement


No requirements but this extension includes CDbCommandBuilder.php core file of Yii version 1.1.14. if you use this version or above just remove CDbCommandBuilder.php from the EmultipleSql folder.


Extract archive in your extensions folder

for multiple inserts check this

  $multipleBuilder = new CDBMultipleCommandBuilder(Yii::app()->db->schema);
//massive updates
      $data = array(
        array('field1' => 'value1', 'field2' => 'value1', 'field3' => 'value1'), //when column_condition = val1
        array('field1' => 'value4', 'field5' => 'value2', 'field3' => 'value6'), //when column_condition = val2
        array('field1' => 'value7', 'field2' => 'value8', 'field3' => 'value9'), //when column_condition = val3
      public $keys = array(
        array('val1','val2','val3'), //the count of items is as the count array items of the data
  $command = $this->multipleBuilder->createMultipleUpdateCommand('your_table_name', $data, $keys);
  $result = $command->execute();
// massive deletes
   $command = $multipleBuilder->createMultipleDeleteCommand('your_table_name', 'the_condition_column', array('value1', 'value2', 'value3'));
   $result = $command->execute();

Be the first person to leave a comment

Please to leave your comment.

Create extension