pymysql快速建表
方法一:(练习实用无优化)
先创建database数据库 创建表字段 再带入代码插入数据
文件名order2.py
import random
def order1():
sql=[]
for s in range(1, 10):
name=random.choice('赵钱孙李周吴郑王')+random.choice("红明娇瑞睿蕊星三")
age=random.randint(18,20)
sex=random.choice('男女')
order= "insert into student(s,sname,sage,ssex) value('%s','%s','%s','%s');"%(s,name,age,sex)
sql.append(order)
return sql
order=order1()
print(order)
文件名:随便
import pymysql
from order2 import order
#创建数据库连接
db=pymysql.connect(
host="localhost",
user="root",
password="123",
database="school",
port=3306,
charset="utf8"
)
cursor=db.cursor()
# cursor.execute('use school')
for sql in order:
cursor.execute(sql)
result=cursor.fetchall()
print(result)
db.commit()
cursor.close()
db.close()