mysql 另一个列插入和主键相同的数据

查询出的主键

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>