How To Update A Column In Sqlite Using Pysqlite Where I First Needed To Obtain A Conditional Value From Other Data In My Table?

So, I have the following issue when updating my database: I have a column in my table that I need to split in three essentially and so I have the following code: with con: cur =

Solution 1:

To update a specific row, you need a way to identify the row. You appear to have an "ID" column, so read that together with the string you want split.

SQL statements have nothing to do with Python; what you do in Python is to construct an SQL string that you then give to the database to execute. (Using ?-style parameters avoids string formatting problems and SQL injection attacks; always use them for values.)

cur.execute('SELECT ID, Column1 FROM MainTable')
forid, col1 in cur.fetchall():
    a, b, c = col1.split('-')
    cur.execute('UPDATE MainTable SET ColA = ?, ColB = ?, ColC = ? WHERE ID = ?',
                [a, b, c, id])
con.commit()