error "column count doesnt match value count at row 1" while inserting new values into table

Question

I'm trying to add new values to the MySQL database table, but there is always an error. I am new to python programming so I don't really know how all of this works. the photo of the error is below.

def add_new():
    eq_name = t1.get()
    total2 = t2.get()
    query = "INSERT INTO Equipment(equipmentID, name, available, borrowed,  total) VALUES(NULL, %s, %s, %s, %s, NOW())"
    cursor.execute(query, (eq_name, total2, 0, total2 ))
    clear()

enter image description here

The problem described in this question doesn't have anything to do with tkinter so please remove that tag — TheLizzard
– TheLizzard, Commented Apr 21, 2021 at 17:16
the question (or problem) has also not much to do with python, maybe you should remove that tag too, and first learn SQL before learning python. — Luuk
– Luuk, Commented Apr 21, 2021 at 17:20
In stead of that picture, you also could have posted "ERROR 1136 (21S01): Column count doesn't match value count at row 1" — Luuk
– Luuk, Commented Apr 21, 2021 at 17:22

Yevhen Kuzmovych · Accepted Answer · 2021-04-27 14:18:11Z

1

(equipmentID, name, available, borrowed,  total)
      ^         ^       ^          ^         ^
      1         2       3          4         5

(NULL, %s, %s, %s, %s, NOW())
  ^     ^   ^   ^   ^   ^
  1     2   3   4   5   6

edited Apr 27, 2021 at 14:18

answered Apr 21, 2021 at 17:20

Yevhen Kuzmovych

12.3k8 gold badges32 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JD2775 Over a year ago

You beat me to it

yahorka Over a year ago

thanks, I just didn't think that NOW() is also a value

Ramon Costa · Accepted Answer · 2021-04-21 17:33:16Z

0

You have 5 columns in the command insert and you are passing 6 values
If it’s auto increment, you don’t need to pass equipmentID
You can automatically retrieve the date and save it.

ALTER TABLE Equipment MODIFY COLUMN createdDt DATETIME DEFAULT CURRENT_TIMESTAMP()

query = "INSERT INTO Equipment(col1, col2, col3, col4, col5) VALUES(NULL, %s, %s, %s, %s, NOW())"
cursor.execute(query, (val1, val2, val3, val4, val5 ))

edited Apr 21, 2021 at 17:33

answered Apr 21, 2021 at 17:21

Ramon Costa

294 bronze badges

1 Comment

Yevhen Kuzmovych Over a year ago

I guess you'd want to remove NOW() now

Collectives™ on Stack Overflow

error "column count doesnt match value count at row 1" while inserting new values into table

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related