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: sql-update
MySQL: Update multiple rows with random values
I have a table called rainfall. It has 2 columns (sensorID, area, time, rainfall, redalert) I want to fill the time column with random times in intervals of 5 minutes (e.g 12:55, 04:30, 07:45) . I managed to get the random times by using this Python code: The problem is that this code fill all rows in time with 1