使用pymysql在MySQL中插入包含多个值的列表

vals = [["TEST1", 1], ["TEST2", 2]]with connection.cursor() as cursor:    cursor.executemany("insert into test(prop, val) values (%s, %s)", vals )    connection.commit()

mysql>从测试中选择*;

+----+-------+------+---------------------+| id | prop  | val  | ts       |+----+-------+------+---------------------+|  1 | TEST1 |    1 | 2017-05-19 09:46:16 ||  2 | TEST2 |    2 | 2017-05-19 09:46:16 |+----+-------+------+---------------------+

改编自https://groups.google.com/forum/#!searchin/pymysql-
users/insert%7Csort:relevance/pymysql-
users/4_D8bYusodc/EHFxjRh89XEJ