Python连接MySQL数据库插入数据的代码

1.首先，导包

import pymysql
import json

2.操作代码

                ################################################
                # 打开数据库连接（ip/数据库用户名/登录密码/数据库名）
                db = pymysql.connect("127.0.0.1", "root", "root", "test")
                # 使用 cursor() 方法创建一个游标对象 cursor
                cursor = db.cursor()
                sql = "REPLACE INTO test (lng, lat,name, address, pname, cityname, adcode, adname, business_area, type, id) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s','%s')"  % \
                      (lng, lat, name, address, pname, cityname, adcode, adname, business_area, type, id)
                # 执行SQL语句
                cursor.execute(sql)
                # 提交到数据库执行
                db.commit()
                # 关闭数据库连接
                db.close()
                ##################################################

附件：建表语句

CREATE TABLE `test` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lng` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cityname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `adcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `adname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `business_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;