【六袆 - Java】Mysql插入一条数据并返回主键ID;Mybatis插入sql返回主键ID;MySQL 插入数据后返回自增ID;Mysql插入数据并返回其主键ID
1.基础SQL
<insert id="insertSku">
insert into sku (pesticide_id,
spe_sku,
spe_sku_name,
spe_sku_value,
status,
create_at,
update_at,
create_by,
update_by)
values (#{pesticideId},
#{speSku},
#{speSkuName},
#{speSkuValue},
1,
now(),
now(),
#{createBy},
#{updateBy}
)
本文来自博客园,作者:你好,Alf,转载请注明原文链接:https://www.cnblogs.com/Alf-/p/16192805.html