sqlite3.OperationalError: no such column: - Python

Question

I am trying to Inserat something from Input into my Database. But getting the Error:

sqlite3.OperationalError: no such column: kundename

import sqlite3

conn = sqlite3.connect('datenbank.db')
print ("Opened database successfully")

kundenname= input("Kundename: ")
auftragstyp= input("Auftragstyp: ")
auftragsurl= input("Auftragsurl: ")
anzahl= input("Anzahl der Bewertungen: ")

conn.execute("INSERT INTO kundenname VALUES (kundename,auftragstyp,auftragsurl,anzahl)", (kundenname, auftragstyp,         auftragsurl,  anzahl))

conn.commit()
print ("Records created successfully")
conn.close()

But if I make like:

import sqlite3

conn = sqlite3.connect('datenbank.db')

print ("Opened database successfully")

conn = conn.execute("SELECT ID, kundename from kundenname")
for row in conn:
print ("ID = ", row[0])
print ("kundename = ", row[1])
print ("Operation done successfully")
conn.close()

then it works and Shows me the Datas in the Base. But why insert saying the colum dosent excist?

Thank you very much!

Typo in kundenname?

Klaus D.
– Klaus D.

2018-01-31 12:26:34 +00:00
Commented Jan 31, 2018 at 12:26 — Klaus D.
– Klaus D., Commented Jan 31, 2018 at 12:26
No, I wrote it like this in DB to ;)

Jerome
– Jerome

2018-01-31 12:37:49 +00:00
Commented Jan 31, 2018 at 12:37 — Jerome
– Jerome, Commented Jan 31, 2018 at 12:37

TzlilSwi · Accepted Answer · 2018-01-31 12:32:50Z

1

I think you have a problem with this line:

conn.execute("INSERT INTO kundenname VALUES 
(kundename,auftragstyp,auftragsurl,anzahl)", (kundenname, auftragstyp,         
auftragsurl,  anzahl))

This is not the way to insert, try this:

conn.execute("INSERT INTO kundenname 
('kundename','auftragstyp','auftragsurl','anzahl') VALUES (" + 
str(kundename) +"," + str(auftragstyp) + "," +  str(auftragsurl) + "," 
+ str(anzahl)+")"

edited Jan 31, 2018 at 12:32

answered Jan 31, 2018 at 12:27

TzlilSwi

946 bronze badges

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

5 Comments

Jerome Over a year ago

It says then: sqlite3.OperationalError: no such column: Michi , he looking as colum what I put into the Input.

Jerome Over a year ago

Only works if I use numbers as Input.. if I add letters then it Comes the error that the colum dosent excist emm

Ron Norris Over a year ago

That's because SQL requires single quotes around each string value, but not for numeric values. So it all depends on your database field types as to how you insert the data. So if auftragsurl is a text field, the VALUE should be like ...",'" + str(auftragsurl) + '","... and an integer insertion looks like ..., anzahl,... assuming anzahl is an integer.

Jerome Over a year ago

I have as kundename ...+ str(kundename) +... and in database kundename is Text. Still he dont add it in the database, he search the Input as a colum and but adding a number it works.. but why if it is TEXT :)

TzlilSwi Over a year ago

I did not understand if it helped you or not...can you please post the updated code?

Ron Norris · Accepted Answer · 2018-01-31 12:56:39Z

0

The interpreter is complaining about your using unquoted strings. It's interpreting them as variable names in your insert statement. Try this:

conn.execute("INSERT INTO kundenname ('kundename','auftragstyp','auftragsurl','anzahl') VALUES (kundenname, auftragstyp,  auftragsurl,  anzahl)")

edited Jan 31, 2018 at 12:56

answered Jan 31, 2018 at 12:25

Ron Norris

2,7001 gold badge12 silver badges13 bronze badges

4 Comments

Jerome Over a year ago

Thanks! Getting the error: sqlite3.OperationalError: near ",": syntax error

Ron Norris Over a year ago

The problem was the comma before the word VALUE. I removed it from the answer.

Jerome Over a year ago

sqlite3.OperationalError: no such column: kundenname

Jerome Over a year ago

And if I Change it into: + str(kundenname) + , it Comes: sqlite3.OperationalError: no such column: Hans

Collectives™ on Stack Overflow

sqlite3.OperationalError: no such column: - Python

2 Answers 2

5 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related