$enableSchemaCache public property Whether to enable schema caching. Note that in order to enable truly schema caching, a valid cache component as specified by $schemaCache must be enabled and $enableSchemaCache must be set true. See also: $schemaCacheDuration $schemaCacheExclude $schemaCache public boolean $enableSchemaCache = false

$enableSavepoint public property Whether to enable savepoint. Note that if the underlying DBMS does not support savepoint, setting this property to be true will have no effect. public boolean $enableSavepoint = true

$enableQueryCache public property Whether to enable query caching. Note that in order to enable query caching, a valid cache component as specified by $queryCache must be enabled and $enableQueryCache must be set true. Also, only the results of the queries enclosed within cache() will be cached. See also: $queryCache cache() noCache() public boolean $enableQueryCache = true

$emulatePrepare public property Whether to turn on prepare emulation. Defaults to false, meaning PDO will use the native prepare support if available. For some databases (such as MySQL), this may need to be set true so that PDO can emulate the prepare support to bypass the buggy native prepare support. The default value is null, which means the PDO ATTR_EMULATE_PREPARES value will not be changed. public boolean $emulatePrepare = null

$dsn public property The Data Source Name, or DSN, contains the information required to connect to the database. Please refer to the PHP manual on the format of the DSN string. For SQLite you may use a path alias for specifying the database path, e.g. sqlite:@app/data/db.sql. See also $charset. public string $dsn = null

$driverName public property Name of the DB driver public string getDriverName ( )public void setDriverName ( $driverName )

$commandClass public property (available since version 2.0.7) The class used to create new database yii\db\Command objects. If you want to extend the yii\db\Command class, you may configure this property to use your extended version of the class. See also createCommand(). public string $commandClass = 'yii\db\Command'

$charset public property The charset used for database connection. The property is only used for MySQL, PostgreSQL and CUBRID databases. Defaults to null, meaning using default charset as configured by the database. For Oracle Database, the charset must be specified in the $dsn, for example for UTF-8 by appending ;charset=UTF-8 to the DSN string. The same applies for if you're using GBK or BIG5 charset with MySQL, then it's highly recommended to specify charset via $dsn like 'mysql:dbname=m

$attributes public property PDO attributes (name => value) that should be set when calling open() to establish a DB connection. Please refer to the PHP manual for details about available attributes. public array $attributes = null

update() public method Creates an UPDATE command. For example, $connection->createCommand()->update('user', ['status' => 1], 'age > 30')->execute(); The method will properly escape the column names and bind the values to be updated. Note that the created command is not executed until execute() is called. public $this update ( $table, $columns, $condition = '', $params = [] )$table string The table to be updated. $columns array The column data (name => value) to be up