bulk insert mysql from list of tuples

Solutions on MaxInterview for bulk insert mysql from list of tuples by the best coders in the world

showing results for - "bulk insert mysql from list of tuples"

24 Jun 2018

1#function to transform your list into a string
2def stringify(v): 
3    return "('%s', '%s', %s, %s)" % (v[0], v[1], v[2], v[3])
4
5#transform all to string
6v = map(stringify, row)
7
8#glue them together
9batchData = ", ".join(e for e in v)
10
11#complete the SQL
12sql = "INSERT INTO `table_name`(`column`, `column_1`, `column_2`, `column_3`) \
13VALUES %s" % batchData
14
15#execute it
16cursor.execute(sql)
17db.commit()
18

source

similar questions

how to subtract of two numbers in mysql mysql select multiple rows into one column how to add multiple condition in mysql query mysql query bulk insert mysql insert into multiple tables insert data into multiple tables mysql mysql insert multiple rows based on select mysql best way to insert many rows insert bulk values into table in sqlite bulk update record sql mysql multiple set statements insert into values multiple mysql insert on dup c3 a8licate update multiple columns in mysql how to insert multiple rows in mysql using stored procedure how to insert same table data using mysql query how to insert multiple records at once in sql acess sql insert bulk list of dictionaries

queries leading to this page

how to insert mutiple rows using mysql connector python bulk insert mysql from list of tuples insert multiple rows sql python bulk insert mysql from list of tuples