pymysql.err.OperationalError: (1364, “Field ‘Id‘ doesn‘t have a default value“)

    def RegTeacher(self):
        ####注册教职工
        cur = self.conn.cursor()
        print()
        title = '    Register New Teacher'
        print(title)
        name = input('           Name:')
        number = input(' Teacher Number:')
        gender = input('         Gender:')
        birth = input('      Born Date:')
        pos = self.PrintPositionInfo()
        position = input('Position Number:')
        salary = input('         Salary:')
        cur = self.conn.cursor()
        sqlcmd = "insert into TeacherInfo(Name, TeacherNo, Gender, Birth, PositionNo, Salary) VALUES ('%s', '%s', '%s', '%s', %s, %s)" % (name, number, gender, birth, position, salary)
        res = cur.execute(sqlcmd)
        info = 'Register Success!'
        if res == 0:
            info = 'Register Fail!'
            self.conn.rollback()
        else:
            sqlcmd = 'select Password from DefaultPassword where AccountLevel = 1'
            if cur.execute(sqlcmd) == 0:
                info = 'Register Fail!'
                self.conn.rollback()
            else:
                pw = cur.fetchone()
                sqlcmd = "insert into LoginAccount(Account,Password,AccountLevel) values('%s','%s',1)" % (number, pw[0])
                if cur.execute(sqlcmd) == 0:
                    info = 'Register Fail!'
                    self.conn.rollback()
                else:
                    self.conn.commit()
        cur.close()
        return info

一个普通的兴建表行的代码但无论怎么运行后都会出现一样的错误

然后去网上找了一样的解决方案把数据库表调成自增

但无论怎么运行还是一样的错误，离谱的我试了手动给id赋值，用时间戳作为id插入，甚至直接把id赋值成1，运行后还是一样的错误，实在没辙了