mysql 添加返回对应id_Mysql插入数据返回对应的自增id（mybatis）

SELECT last_insert_id()INSERT

INTO finance_apply

(money,

from_account_id,

to_account_id,

apply_type,

applier_id,

apply_time,

approver_id,approved_time,status,

remark,

business_id,

bank_order_id,

qcompany_id,

qaccount_id,

payer,

approval_remark,

recharge_date,

is_company,

applier_name,

approver_name,

customer_name,

customer_account,

customer_account_number,

customer_city,reset_status,

manual_claim_status,

financialSystem_Type,transfer_type,

transaction_id

)VALUES(

#{money},

#{fromAccountId},

#{toAccountId},

#{applyType},

#{applierId},

now(),

#{approverId},#{approvedTime},#{status},

#{remark},

#{businessId},

#{bankOrderId},

#{qcompanyId},

#{qaccountId},

#{payer},

#{approvalRemark},

#{rechargeDate},

#{isCompany},

#{applierName},

#{approverName},

#{customerName},

#{customerAccount},

#{customerAccountNumber},

#{customerCity},#{resetStatus},

#{manualClaimStatus},

#{financialSystemType},#{transferType},

#{transactionId}

);