1 ==================查询================== 2 $data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->query();//执行一个非查询的sql语句 3 $data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->queryAll();//返回多行数据 4 $data = Yii::app()->db->createCommand('select * from admin where id between 1 and 10')->queryRow();//返回一行数据 5 $data = Yii::app()->db->createCommand('select id from admin where id between 1 and 10')->queryColumn();//返回多个指定字段的值 6 $data = Yii::app()->db->createCommand('select id from admin where id between 1 and 10')->queryScalar();//返回一个指定字段的值 7 8 ==================新增================== 9 $insert = Yii::app()->db->createCommand()->insert('admin', ['id' => 1, 'name' => '你好']); 10 $insertId = Yii::app()->db->getLastInsertID();//获取插入数据的主键ID 11 $insert = Yii::app()->db->createCommand()->batchInsert('admin', ['id', 'name'], [1, '你好'], [2, '你好'], [3, '你好']); 12 13 ==================修改================== 14 $update = Yii::app()->db->createCommand()->update('admin', ['name' => '你好呀'], 'id = 1');//修改admin表，id = 1 name的值为'你好呀'，set name = '你好呀' where id = 1 15 16 ==================删除================== 17 $delete = Yii::app()->db->createCommand()->delete('admin', 'id = 1');//删除admin表id = 1的数据