用python操作mysql数据库实现添加一条数据:
# coding = utf-8
import pymysql
# 连接
conn = pymysql.connect(host='localhost',
user='root',
password='root1234',
database='test_interface',
port=3306,
charset='utf8')
# 游标
cur = conn.cursor()
# sql语句
sql_insert = "insert into config_total(key_config, value_config, description, status) values('mytest1', 'mytest11', '我的测试 1', 1);"
# 执行sql
cur.execute(sql_insert)
# 提交数据到数据库
conn.commit()
# 关闭游标
cur.close()
# 关闭连接
conn.close()
python操作mysql数据库实现批量添加数据:
# coding = utf-8
import pymysql
# 连接
conn = pymysql.connect(host='localhost',
user='root',
password='root1234',
database='test_interface',
port=3306,
charset='utf8')
# 游标
cur = conn.cursor()
# sql语句
# sql_insert = "insert into config_total(key_config, value_config, description, status) values('mytest1', 'mytest11', '我的测试 1', 1);"
# 批量添加数据
sql_insert = "insert into config_total(key_config, value_config, description, status) values('mytest1', 'mytest11', '我的测试 1', 1)," \
"('mytest2', 'mytest22', '我的测试 3', 1), ('mytest3', 'mytest33', '我的测试 3', 3);"
# 执行sql
cur.execute(sql_insert)
# 提交数据到数据库
conn.commit()
# 关闭游标
cur.close()
# 关闭连接
conn.close()