Get the App
SLTechnology News&Howtos  ›  Database  › 

Mybatis+MySQL UUID primary key generation strategy

Shulou Source: shulou.com Published: 2022-06-01 16:47:20 11月17日 Update

SELECT REPLACE (UUID (),'-',') FROM DUAL

Insert into spm_invoice (invoiceId, invoiceNum, invoiceItem

InvoiceDate, invoiceMoney, clientId

ClientDepId, linkMan, invoiceStatusId

UploadFileName, uploadFilePath, uploadFileDate

Remark)

Values (# {invoiceid,jdbcType=VARCHAR}, # {invoicenum,jdbcType=VARCHAR}, # {invoiceitem,jdbcType=VARCHAR})

# {invoicedate,jdbcType=DATE}, # {invoicemoney,jdbcType=DOUBLE}, # {clientid,jdbcType=INTEGER}

# {clientdepid,jdbcType=INTEGER}, # {linkman,jdbcType=VARCHAR}, # {invoicestatusid,jdbcType=VARCHAR}

# {uploadfilename,jdbcType=VARCHAR}, # {uploadfilepath,jdbcType=VARCHAR}, # {uploadfiledate,jdbcType=TIMESTAMP}

# {remark,jdbcType=LONGVARCHAR})

Tags: Policies generatin Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Apple Microsoft MySQL Docker