c++ datetime mysql,mysql case 语言使用(按日期插表)

DROPPROCEDUREIFEXISTS`Sp_SendRequest`;

DELIMITER ;;CREATEPROCEDURESp_SendRequest(

inRequestIDVarchar(32),

inRequestTagIDint(11),

inSendIDvarchar(30),

inOwnerIDvarchar(30)

)BEGINset@days:=0;set@timestamps:=UNIX_TIMESTAMP();selectfrom_unixtime(@timestamps,'%d')into@days;case@dayswhen1theninsertintoTbl_FreeGift_01(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when2theninsertintoTbl_FreeGift_02(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when3theninsertintoTbl_FreeGift_03(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when4theninsertintoTbl_FreeGift_04(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when5theninsertintoTbl_FreeGift_05(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when6theninsertintoTbl_FreeGift_06(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when7theninsertintoTbl_FreeGift_07(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when8theninsertintoTbl_FreeGift_08(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when9theninsertintoTbl_FreeGift_09(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when10theninsertintoTbl_FreeGift_10(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when11theninsertintoTbl_FreeGift_11(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when12theninsertintoTbl_FreeGift_12(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when13theninsertintoTbl_FreeGift_13(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when14theninsertintoTbl_FreeGift_14(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when15theninsertintoTbl_FreeGift_15(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when16theninsertintoTbl_FreeGift_16(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when17theninsertintoTbl_FreeGift_17(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when18theninsertintoTbl_FreeGift_18(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when19theninsertintoTbl_FreeGift_19(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when20theninsertintoTbl_FreeGift_20(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when21theninsertintoTbl_FreeGift_21(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when22theninsertintoTbl_FreeGift_22(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when23theninsertintoTbl_FreeGift_23(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when24theninsertintoTbl_FreeGift_24(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when25theninsertintoTbl_FreeGift_25(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when26theninsertintoTbl_FreeGift_26(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when27theninsertintoTbl_FreeGift_27(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when28theninsertintoTbl_FreeGift_28(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when29theninsertintoTbl_FreeGift_29(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when30theninsertintoTbl_FreeGift_30(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);when31theninsertintoTbl_FreeGift_31(RequestID,RequestTagID,SendID,OwnerID,StartTimeStamp)values(inRequestID,inRequestTagID,inSendID,inOwnerID,@timestamps);endcase;END;;