mysql last insert id
mysql autoincreament 일 때 다음에 사용할 index 가져오기
<insert id="insert" parameterType="DeviceErrorLog">
INSERT INTO <include refid="tableName"/>
(
<include refid="baseColumns"/>
)
VALUES
(
<include refid="baseValues"/>
)
<selectKey resultType="_int" keyProperty="id" order="AFTER" >
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
<insert id="insert" parameterType="DeviceErrorLog">
INSERT INTO <include refid="tableName"/>
(
<include refid="baseColumns"/>
)
VALUES
(
<include refid="baseValues"/>
)
<selectKey resultType="_int" keyProperty="id" order="AFTER" >
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
댓글
댓글 쓰기