Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- parsed_string = json.loads(json_string)
- cursor.execute("update Table set Status = ? where Name like ? ",(json.dumps(parsed_string), "Blabla"))
- cnxn.commit()
- cursor.execute("""select Status from Table where Name like ?""", "Blabla")
- cursor.fetchall()
- "{"orderID": 42, "orderContents": [{"productName": "keyboard", "quantity": 1, "productID": 23}, {"productName": "mouse", "quantity": 1, "productID": 13}],
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement