Yii框架1版本数据操作-直接数据库

==================查询==================
$data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->query();//执行一个非查询的sql语句
$data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->queryAll();//返回多行数据
$data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->queryRow();//返回一行数据
$data = Yii::app()->db->createCommand('select id from admin where id between 1 and 10')->queryColumn();//返回多个指定字段的值
$data = Yii::app()->db->createCommand('select id from admin where id between 1 and 10')->queryScalar();//返回一个指定字段的值

==================新增==================
$insert = Yii::app()->db->createCommand()->insert('admin', ['id' => 1, 'name' => '你好']);
$insertId = Yii::app()->db->getLastInsertID();//获取插入数据的主键ID
$insert = Yii::app()->db->createCommand()->batchInsert('admin', ['id', 'name'], [1, '你好'], [2, '你好'], [3, '你好']);

==================修改==================
$update = Yii::app()->db->createCommand()->update('admin', ['name' => '你好呀'], 'id = 1');//修改admin表，id = 1 name的值为'你好呀'，set name = '你好呀' where id = 1

==================删除==================
$delete = Yii::app()->db->createCommand()->delete('admin', 'id = 1');//删除admin表id = 1的数据