Mysql 插入自增的最大版本号

有一个需求,在历史表中,一条数据,在最大版本号上进行自增

INSERT Biz_CourseStudyHistory (
    contentStudyID,
    courseWareID,
    versionNO
)
SELECT
            contentStudyID,
            courseWareID,
            (SELECT
            max(versionNO) + 1
        FROM
            Biz_CourseStudyHistory
        WHERE
            contentStudyID = 1
        AND courseWareID = 1) 
        FROM
            Biz_CourseStudyHistory
        WHERE
            contentStudyID = 1  AND
          courseWareID = 1
LIMIT 1