yii基本添加，修改，删除，查询db语句

//添加Yii::app()->db->createCommand()->insert('tbl_user',   array('username' => 'zhangsan','email' => '[e-mail]'));//修改     Yii::app()->db->createCommand()->update('tbl_user',   array('username' => 'Tester'),   'id=:id',   array(':id' => 3));//删除        Yii::app()->db->createCommand()->delete('tbl_user',   'id=:id',   array(':id' => 2));//查询 - 多条数据     $users = Yii::app()->db->createCommand()   ->select('*')   ->from('tbl_user')   ->queryAll();//查询一条数据$sql = "SELECT id,name FROM tbl_user WHERE email='[e-mail]'";   $users=Yii::app()->db->createCommand($sql)->queryRow();