batchInsert() public method Generates a batch INSERT SQL statement. For example, $connection->createCommand()->batchInsert('user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ])->execute(); Note that the values in each row must match the corresponding column names. public string 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 inse

alterColumn() public method Builds a SQL statement for changing the definition of a column. public string 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 new column type. The getColumnType() method will be invoked to convert abstract column type (if any) into the physica

addPrimaryKey() public method Builds a SQL statement for adding a primary key constraint to an existing table. public string 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 string The SQL statement for adding a primary key constraint to an existing table

addForeignKey() public method Builds a SQL statement for adding a foreign key constraint to an existing table. The method will properly quote the table and column names. public string addForeignKey ( $name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null )$name string The name of the foreign key constraint. $table string The table that the foreign key constraint will be added to. $columns string|array The name of the column to that the constraint will be ad

addCommentOnTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public string 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 string The SQL statement for adding comment on table throws yii\base\NotSupportedException

addCommentOnColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string 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

$typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\sqlite\Schema::TYPE_PK => 'integer PRIMARY KEY AUTOINCREMENT NOT NULL', \yii\db\sqlite\Schema::TYPE_UPK => 'integer UNSIGNED PRIMARY KEY AUTOINCREMENT NOT NULL', \yii\db\sqlite\Schema::TYPE_BIGPK => 'integer PRIMARY KEY AUTOINCREMENT NOT NULL', \yii\db\sqlite\Schema::TYPE_UBIGPK => 'integer UNSIGNED PRIMARY KEY AUTOINCREMENT NOT NULL', \yii\db\s

__toString() public method Builds the full string for the column's schema public string __toString ( )

buildUnsignedString() protected method Builds the unsigned string for column. Defaults to unsupported. protected string buildUnsignedString ( )return string A string containing UNSIGNED keyword.

timestamp() public method (available since version 2.0.6) Creates a timestamp column. public yii\db\ColumnSchemaBuilder timestamp ( $precision = null )$precision integer Column value precision. First parameter passed to the column type, e.g. TIMESTAMP(precision). This parameter will be ignored if not supported by the DBMS. return yii\db\ColumnSchemaBuilder The column instance which can be further customized.