I have found similar questions, but none that cover my exact situation. I have a table (lets call it A), one of the columns is composed of integers. I want to update this column, from a different table (lets call it B), which contains several columns of integers, one of which I want to use to update the column in A. To be clear, I don't want to add more columns to A nor are all the integers the same. I do appreciate Python has many methods, but the other queries I an using are based around the kind of approach: mydb = mysql.connector.connect( All my database details ) mycursor = mydb.cursor() mycursor.excecute(This is the bit I need with %s variable) val = (column I need in B, ) and I'd like to stick with this if possible. Continue reading...
