Zend Framework直接查询SQL

代码：

$db = &$this->getAdapter();
$sql = "UPDATE t_scoreclass AS sc
                SET sequence_name=(SELECT sequence_name 
                    FROM t_exams AS ex
                    WHERE sc.sequence=ex.sequence AND sc.type=ex.type GROUP BY sequence_name) WHERE sc.type= ".$type." AND sc.sequence = ".$sequence.";";
$db->query($sql);

说明：使用query就可以了，可以直接查询任意的sql语句，增删改查。