我有下面的Mongoose函数，我正在尝试做一个选择WHEREemail=req.body.email和referenceId不在数组中。referenceId是一个字符串数组[String]，它有一个对象ID数组。constrefereeSchema=newSchema({firstName:{type:String,required:true},lastName:{type:String,required:true},email:{type:String,required:true,unique:true},referenceId:[{type:mongoose.Schema.Ty

我有下表:CREATETABLE`some_table`(`ReferenceId`int(11)DEFAULTNULL,`ten`int(10)DEFAULTNULL,`so`bigint(18)DEFAULTNULL,`mc`bigint(18)DEFAULTNULL,`ev`bigint(18)DEFAULTNULL,`sclso`bigint(18)DEFAULTNULL,`sowbse`bigint(18)DEFAULTNULL,`AsOfDate`dateDEFAULTNULL,`dud`dateNOTNULL,UNIQUEKEY`ReferenceId`(`Referen

我如何重写以下SP以面对MySQL中的递归限制:CREATEDEFINER=`root`@`localhost`PROCEDURE`SP_DeleteParentDirectory`(pParentIDINT,pIsFolderINT,pReferenceIDINT)BEGINSET@@SESSION.max_sp_recursion_depth=255;SET@IsFolder=NULL;SET@ChildID=NULL;SET@ReferenceID=NULL;IF(pIsFolder=2)THENSELECTFileIDINTO@ChildIDFROMfilesinfoWHERE