MySQL中yii2使用原生sql CURD

批量插入数据：

Yii::$app->db->createCommand()->batchInsert('ac_users', ['email', 'password', 'first_name'],
[
['james.franklin@example.com', 'changeme7', 'James'],
['linda.marks@example.com', 'changeme7', 'Linda']
['roger.martin@example.com', 'changeme7']
])->execute();

更新数据：

Yii::$app->db->createCommand()->update('ac_users', ['updated_at' => time()], 'id = 2')->execute();

删除数据：

Yii::$app->db->createCommand()->delete('ac_users', 'id = 3')->execute();

获取所有数据(数组返回格式)：

Yii::$app->db->createCommand("SELECT * FROM `ac_users`")->queryAll();

查询一条数据：

Yii::$app->db->createCommand("SELECT * FROM `ac_users` WHERE id = 1")->queryOne();

获取一个值：

Yii::$app->db->createCommand("SELECT count(*) AS total FROM `ac_users` WHERE id = 1")->queryScalar();

获取某一列：

Yii::$app->db->createCommand("SELECT username FROM `ac_users`")->queryColumn();

 执行原生SQL：

Yii::$app->db->createCommand("DELETE A FROM ddos_bizip AS A INNER JOIN ddos_statusip AS B ON A.id = B.ipid WHERE A.segmentid = ".$id)->execute();