Python-сообщество

    conn  = sqlite3.connect(name)
    cur = conn.cursor()

    cur.execute("""
    create table Department
       (Department_ID   integer primary key AUTOINCREMENT,
        Name             text);
    """)


    department_data = (u'Бухгалтерия', u'Строительный отдел',
                       u'Отдел снабжения', u'Плановый отдел',
                       u'Кадровый отдел')

    cur.executemany("insert into Department(Name) values (?)", department_data))
    cur.commit()

ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 11 supplied.

    for i in department_data:
        cur.execute("insert into Department(Name) values (?)", (i,))

    department_data = [(u'Бухгалтерия', ), (u'Строительный отдел', ),
                       (u'Отдел снабжения', ), (u'Плановый отдел', ),
                       (u'Кадровый отдел', )]

    cur.executemany("insert into Department(Name) values (?)", department_data))