测试表表结构
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for test_demo
DROP TABLE IF EXISTS test_demo;
CREATE TABLE test_demo (
id int NOT NULL AUTO_INCREMENT,
name varchar(108) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
age varchar(526) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
content varchar(526) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;
python 链接数据库
导入pymysql包
import pymysql
创建数据库连接
conn = pymysql.connect(host=“localhost”, port=3306, user=“root”, passwd=“123456”, db=“data_test”)
id = ‘null’
获取一个游标对象
cursor = conn.cursor()
设置参数i，for语句循环
for i in range(1, 10):
param_data = str(i)
sql = “insert into test_demo values({0}, ‘{1}’, ‘{2}’, ‘{3}’)”.format(id, “xiao_ming”, param_data, “三好学生”)
cursor.execute(sql)
conn.commit()
关闭连接
conn.close()
cursor.close()
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/76861.html
