addCommentOnTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public $this addCommentOnTable ( $table, $comment )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $comment string The text of the comment to be added. The comment will be properly quoted by the method. return $this The command object itself

addCommentOnColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public $this addCommentOnColumn ( $table, $column, $comment )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $column string The name of the column to be commented. The column name will be properly quoted by the method. $comment string The text of the comment to be added. The comment will be properly quoted

addColumn() public method Creates a SQL command for adding a new DB column. public $this addColumn ( $table, $column, $type )$table string The table that the new column will be added to. The table name will be properly quoted by the method. $column string The name of the new column. 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. For example, string w

$sql public property The SQL statement to be executed public string getSql ( )public $this setSql ( $sql )

$rawSql public read-only property The raw SQL with parameter values inserted into the corresponding placeholders in $sql. public string getRawSql ( )

$queryCacheDuration public property The default number of seconds that query results can remain valid in cache. Use 0 to indicate that the cached data will never expire. And use a negative number to indicate query cache should not be used. See also cache(). public integer $queryCacheDuration = null

$queryCacheDependency public property The dependency to be associated with the cached query result for this command See also cache(). public yii\caching\Dependency $queryCacheDependency = null

$pdoStatement public property The PDOStatement object that this command is associated with public PDOStatement $pdoStatement = null

$params public property The parameters (name => value) that are bound to the current PDO statement. This property is maintained by methods such as bindValue(). It is mainly provided for logging purpose and is used to generate $rawSql. Do not modify it directly. public array $params = []

$fetchMode public property The default fetch mode for this command. See also http://www.php.net/manual/en/function.PDOStatement-setFetchMode.php. public integer $fetchMode = \PDO::FETCH_ASSOC