replace() public method Creates an REPLACE command. For example, $connection->createCommand()->replace('idx_user', [ 'name' => 'Sam', 'age' => 30, ])->execute(); The method will properly escape the column names, and bind the values to be replaced. Note that the created command is not executed until execute() is called. public $this replace ( $index, $columns )$index string The index that new rows will be replaced into. $columns array The column data (name =>

renameTable() public method Creates a SQL command for renaming a DB table. public $this renameTable ( $table, $newName )$table string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return $this The command object itself

renameColumn() public method Creates a SQL command for renaming a column. public $this renameColumn ( $table, $oldName, $newName )$table string The table whose column is to be renamed. The name will be properly quoted by the method. $oldName string The old name of the column. The name will be properly quoted by the method. $newName string The new name of the column. The name will be properly quoted by the method. return $this The command object itself

prepare() public method Prepares the SQL statement to be executed. For complex SQL statement that is to be executed multiple times, this may improve performance. For SQL statement with binding parameters, this method is invoked automatically. public void prepare ( $forRead = null )$forRead boolean Whether this method is called for a read query. If null, it means the SQL statement should be used to determine whether it is for read or write. throws yii\db\Exception if there is any DB err

dropTable() public method Creates a SQL command for dropping a DB table. public $this dropTable ( $table )$table string The table to be dropped. The name will be properly quoted by the method. return $this The command object itself

dropPrimaryKey() public method Creates a SQL command for removing a primary key constraint to an existing table. public $this dropPrimaryKey ( $name, $table )$name string The name of the primary key constraint to be removed. $table string The table that the primary key constraint will be removed from. return $this The command object itself

dropIndex() public method Creates a SQL command for dropping an index. public $this dropIndex ( $name, $table )$name string The name of the index to be dropped. The name will be properly quoted by the method. $table string The table whose index is to be dropped. The name will be properly quoted by the method. return $this The command object itself

dropForeignKey() public method Creates a SQL command for dropping a foreign key constraint. public $this dropForeignKey ( $name, $table )$name string The name of the foreign key constraint to be dropped. The name will be properly quoted by the method. $table string The table whose foreign is to be dropped. The name will be properly quoted by the method. return $this The command object itself

dropColumn() public method Creates a SQL command for dropping a DB column. public $this dropColumn ( $table, $column )$table string The table whose column is to be dropped. The name will be properly quoted by the method. $column string The name of the column to be dropped. The name will be properly quoted by the method. return $this The command object itself

createTable() public method Creates a SQL command for creating a new DB table. The columns in the new table should be specified as name-definition pairs (e.g. 'name' => 'string'), where name stands for a column name which will be properly quoted by the method, and definition stands for the column type which can contain an abstract DB type. The method yii\sphinx\QueryBuilder::getColumnType() will be called to convert the abstract column types to physical ones. For example, string will be