I currently have a list of id’s approx. of size 10,000. I need to update all rows in the mySQL table which have an id in the inactive_ids list that you see below. I need to change their active status to ‘No’ which is a column in the mySQL table. I am using mysql.connector python library. When I run the
Tag: mysql-connector-python
Django 3.x error: ‘mysql.connector.django’ isn’t an available database backend
Having recently upgraded a Django project from 2.x to 3.x, I noticed that the mysql.connector.django backend (from mysql-connector-python) no longer works. The last version of Django that it works with is 2.2.11. It breaks with 3.0. I am using mysql-connector-python==8.0.19. When running manage.py runserver, the following error occurs: I am aware that this is not an official Django backend but
mysql-connector-python query with WHERE IN
I am trying to query a table with WHERE IN condition using mysql-connector-python like this: And I get the following error: How can I get it working? Answer You should add “” in ids to be a String and also ‘,’ should be replaced with ‘%’ E.g.