Advertisement
Guest User

insert python mysql

a guest
Apr 23rd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.41 KB | None | 0 0
  1. rows = cursor_characters_mop.fetchall()
  2. for row in rows:
  3.     query_insert = "INSERT INTO character_achievement_progress ( " + '{}, ' * 2 + '{}' + " ) VALUES ( " + '{}, ' * 2 + '{}' + " )"
  4.     query_insert = query_insert.format(*(list(characters_achievement_fields.keys()) + ["'{}'".format(column) for column in row]))
  5.  
  6.     # Execute the SQL command
  7.     cursor_characters_wod.execute(query_insert)
  8.     db_characters_wod.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement