前言
向数据库的表中插入数据,需要指定数据库以及表,最后执行插入语句即可
一、创建表sql
# 创建表SQL
def cerate_table(table_name):
sql = "CREATE TABLE IF NOT EXISTS {} (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255),mobile VARCHAR(255))".format(
table_name)
mycursor.execute(sql)
mycursor.commit()
二、插入数据sql
# 插入表数据SQL
def insert_data(table_name, name, address, mobile):
ins_sql = "INSERT INTO {}(name,address,mobile)VALUES ('{}', '{}','{}');"
sql = ins_sql.format(table_name, name, address, mobile)
print("sql", sql)
mycursor.execute(sql)
mycursor.commit()
三、插入数据操作
代码如下(示例):
import pymysql
mydb =pymysql.connect(
host="192.168.90.90",
user="root",
password="xxx",
database="mydatabase"
)
mycursor = mydb.cursor()
cerate_table(table_name="student")
# 插入1000条数据
for i in range(1,1001):
name = '哈哈' + str(i)
address = "广州" + str(100+i) + "号"
insert_data(table_name="student",name=name, address=address)