使用python对数据库进行操作的总结:
import random
from pymysql import cursors,connect
conn=connect(host='127.0.0.1',
user='root',
password='admin',
db='test',
charset='utf8',
cursorclass=cursors.DictCursor)
students_num=100
###函数区#####
def random_name():
t_name_len = random.randint(3, 10)
t_name=""
for i in range(t_name_len):
if i == 0:
t_name=t_name+chr(random.randint(97, 122)).upper()
else:
t_name = t_name + chr(random.randint(97, 122))
return t_name
###函数区#####
try:
with conn.cursor() as cursor:
###创建表
create_sql = 'create table students(num INT NULL AUTO_INCREMENT,' \
'name VARCHAR(12) default NULL,' \