$enableSlaves public property Whether to enable read/write splitting by using $slaves to read data. Note that if $slaves is empty, read/write splitting will NOT be enabled no matter what value this property takes. public boolean $enableSlaves = 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

$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

$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'

$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 )

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

$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

$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