1.订单号空白
函数问题,重新生成一下:
DROPTABLEIFEXISTSe_sequence;
CREATETABLEe_sequence(
nameVARCHAR(50)NOTNULL,
current_valueINTNOTNULL,
incrementINTNOTNULLDEFAULT1,
PRIMARYKEY(name)
)ENGINE=InnoDB;
INSERTINTOe_sequenceVALUES('OrderCodeSeq',0,1);
DROPFUNCTIONIFEXISTSseq_currval;
DELIMI