mysql向数据库中插入数据Demo

阿里云国内75折回扣微信号：monov8

阿里云国际，腾讯云国际，低至75折。AWS 93折免费开户实名账号代冲值优惠多多微信号：monov8 飞机：@monov6

测试表表结构

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()

设置参数ifor语句循环

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()