MyBatis主键自增和【java.sql.SQLException: Field ‘id‘ doesn‘t have a default value】

mapper

添加两个属性：useGeneratedKeys="true" keyProperty="id"

<insert id="add" parameterType="Project" useGeneratedKeys="true" keyProperty="id">
        insert into project (name, description, level, picture, deleted, create_time, update_time, version)
        value (#{name}, #{description}, #{level}, #{picture}, #{deleted}, #{createTime}, #{updateTime},#{version} );
    </insert>

测试

@Test
    public void ddTest(){
        Project project = new Project();
        project.setName("计算机网络");
        project.setDeleted(0);
        project.setCreateTime(new Date());
        project.setDescription("这是一个描述");
        project.setLevel(1);
        project.setPicture("www.baidu.com");
        project.setUpdateTime(new Date());
        project.setVersion(1);

        boolean add = projectService.add(project);
        System.out.println(add);

    }

报错：

原因是虽然mybatis主键自增开启了，但是数据库不买账，需要手动设置一下，开启自动递增