/SQL/Select sqlite3.OperationalError: no such column:

Select sqlite3.OperationalError: no such column:

Sqlite operational error no such column

'''
If you add a column to a table after you have initialized the model, you have to delete the database and initialize the model again.
'''

2

Select sqlite3.OperationalError: no such column:

cursor.execute("SELECT * FROM students WHERE ID=? AND name=? AND age=?", (123, "Steve", 17))

0

Source: stackoverflow.com

Similar codes

16 votes253 views6 answers
Python sqlite
SQL
0 vote211 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote235 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote192 views1 answer
How many columns can be used for creating index?
SQL
1 vote198 views1 answer
Create temporal table in sql
SQL
0 vote202 views1 answer
Oracle simple quote
SQL
0 vote191 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote199 views1 answer
Sql get number of days between two dates
SQL
5 votes267 views1 answer
Migrate sql table another database
SQL
17 votes261 views6 answers
MySQL ORDER BY
SQL

Share