|
Yii DAO will automatically convert such constructs into the corresponding quoted column or table names using the DBMS specific syntax. For example,
|
|
// exécute cette instruction SQL pour MySQL: SELECT COUNT(`id`) FROM `employee` $count = Yii::$app->db->createCommand("SELECT COUNT([[id]]) FROM {{employee}}") ->queryScalar();
|
|
El método yii\db\Command::execute() retorna el número de filas afectadas por la ejecución SQL.
|
|
// MySQL では SELECT COUNT(`id`) FROM `employee` という SQL が実行される $count = Yii::$app->db->createCommand("SELECT COUNT([[id]]) FROM {{employee}}") ->queryScalar();
|
|
// table name, column names, column values Yii::$app->db->createCommand()->batchInsert('user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ])->execute();
|