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

callKeywords() public method Returns tokenized and normalized forms of the keywords, and, optionally, keyword statistics. public $this callKeywords ( $index, $text, $fetchStatistic = false )$index string The name of the index from which to take the text processing settings $text string The text to break down to keywords. $fetchStatistic boolean Whether to return document and hit occurrence statistics return $this The command object itself

checkIntegrity() public method Builds a SQL command for enabling or disabling integrity check. public $this checkIntegrity ( $check = true, $schema = '', $table = '' )$check boolean Whether to turn on or off the integrity check. $schema string The schema name of the tables. Defaults to empty string, meaning the current or default schema. $table string The table name. return $this The command object itself throws yii\base\NotSupportedException if this is not supported by the under

callSnippets() public method Builds a snippet from provided data and query, using specified index settings. public $this callSnippets ( $index, $source, $match, $options = [] )$index string Name of the index, from which to take the text processing settings. $source string|array Is the source data to extract a snippet from. It could be either a single string or array of strings. $match string The full-text query to build snippets for. $options array List of options in format: opti

bindValues() public method Binds a list of values to the corresponding parameters. This is similar to bindValue() except that it binds multiple values at a time. Note that the SQL data type of each value is determined by its PHP type. public $this bindValues ( $values )$values array The values to be bound. This must be given in terms of an associative array with array keys being the parameter names, and array values the corresponding parameter values, e.g. [':name' => 'John', ':age' =

bindValue() public method Binds a value to a parameter. public $this bindValue ( $name, $value, $dataType = null )$name string|integer Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form :name. For a prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter. $value mixed The value to bind to the parameter $dataType integer SQL data type of the parameter. If null, the type

batchReplace() public method Creates a batch REPLACE command. For example, $connection->createCommand()->batchReplace('idx_user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ])->execute(); Note that the values in each row must match the corresponding column names. public $this batchReplace ( $index, $columns, $rows )$index string The index that new rows will be replaced. $columns array The column names $rows array The rows to be batch replaced i

addPrimaryKey() public method Creates a SQL command for adding a primary key constraint to an existing table. The method will properly quote the table and column names. public $this addPrimaryKey ( $name, $table, $columns )$name string The name of the primary key constraint. $table string The table that the primary key constraint will be added to. $columns string|array Comma separated string or array of columns that the primary key will consist of. return $this The command object

alterColumn() public method Creates a SQL command for changing the definition of a column. public $this alterColumn ( $table, $column, $type )$table string The table whose column is to be changed. The table name will be properly quoted by the method. $column string The name of the column to be changed. The name will be properly quoted by the method. $type string The column type. yii\db\QueryBuilder::getColumnType() will be called to convert the give column type to the physical one. F

batchInsert() public method Creates a batch INSERT command. For example, $connection->createCommand()->batchInsert('idx_user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ])->execute(); Note that the values in each row must match the corresponding column names. public $this batchInsert ( $index, $columns, $rows )$index string The index that new rows will be inserted into. $columns array The column names $rows array The rows to be batch inserted