方式一:
SELECT @@IDENTITY
INSERT INTO user_ftp_log(ftp_name,sql_content,error_reason,status,ftp_url,user_id,create_time,create_user,update_time,update_user,total_consume_time)
VALUES(#{ftpName},#{sqlContent},#{errorReason},#{status},#{ftpUrl},#{userId},#{createTime},#{createUserId},#{updateTime},#{updateUserId},#{totalConsumeTime})
方法二:
INSERT INTO user_ftp_log(ftp_name,sql_content,error_reason,status,ftp_url,user_id,create_time,create_user,update_time,update_user,total_consume_time)
VALUES(#{ftpName},#{sqlContent},#{errorReason},#{status},#{ftpUrl},#{userId},#{createTime},#{createUserId},#{updateTime},#{updateUserId},#{totalConsumeTime})
打印结果: