Mysql Returned Datatype And Python Outputs Different Type For Different Functions

I am having plenty of problems with the MySQL returns and entering it into a Qt table with python. I use data = cursor.fetchall() for data in data: for i in range(len(data)):

Solution 1:

You cannot change the data from the fetchall method since it is a tuple and not a list. The easiest fix would be to do:

data = [list(i) for i in cursor.fetchall()]

Solution 2:

From your error log, I think problem happens because tuple in python doesn't support assignment.

Return values you fetch are ready-only tuple so it's invalid to change value directly on that.

In your code :

    data[i] = data[i].strftime("%Y-%m-%d %H:%M:%S")

Do you want to revise original data stored in DB directly? If not, you could use another variable with list type, like:

    my_list = data[i].strftime("%Y-%m-%d %H:%M:%S")
    // TODO MORE

Otherwise you may rely on update sentence to reivse data in DB.