查询出的主键
select AUTO_INCREMENT from information_schema.tables where table_name='msg_archive'
举例:
<insert id="save" parameterType="com.xxx.crm.message.entity.ArchiveDO">
insert into msg_archive
(
`archive_id`,
`archive_name`,
`archive_explain`,
`archive_file_name`,
`archive_file_path`,
`create_user`,
`archive_order`
)
values
(
#{archiveId},
#{archiveName},
#{archiveExplain},
#{archiveFileName},
#{archiveFilePath},
#{createUser},
(select AUTO_INCREMENT from information_schema.tables where table_name='msg_archive')
)
</insert>