[ 错误 ] select @classname=classname,@chargeteacher from classes where classid=@classid
[ 正确 ] select @classname=classname,@chargeteacher=chargeteacher from classes where classid=@classid
全部都应该是"赋值语句"才是正确的