使用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,' \
                                                'score INT,' \
                                                'PRIMARY KEY (num));'
        cursor.execute(create_sql)
        ###增加数据
        add_sql = 'insert into students values'
        for i in range(students_num):
            t_score = random.randint(50, 100)
            add_sql=add_sql+'('+str(100+i)+','+'\''+random_name()+'\''+','+str(t_score)+'),'
        add_sql=add_sql[0:-1]+";"
        cursor.execute(add_sql)
        conn.commit()
        ###修改数据
        update_sql = 'update students set name=concat_ws(\'-\',\'a\',name)'+'where length(name) < 4;'
        cursor.execute(update_sql)
        conn.commit()
        ###删除数据
        for i in range(students_num):
            if i % 2 == 0:
                delete_sql='delete from students where num='+str(100+i)+';'
                cursor.execute(delete_sql)
                conn.commit()
        ###查看数据库
        select_sql = 'select * from students;'
        cursor.execute(select_sql)
        results = cursor.fetchall()
        for iline in results:
            print(iline)
finally:
    conn.close()