代碼
import pymysql
import string
import random
KEY_VALUE = 20
KEY_NUMBER = 200
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='passwd', db='python_practice')
def all_str():
return string.ascii_letters + string.digits
def insert_into_db(cur, data): # 特別愚蠢的寫法
sql_insert_into_table = 'insert into voucher(key_value) VALUE (%s)'
cur.execute(sql_insert_into_table, data)
conn.commit()
def query_data(cur):
sql_query_db = 'select * from voucher WHERE id BETWEEN 20 AND 30'
cur.execute(sql_query_db)
for i in cur.fetchall():
print(i)
conn.commit()
def insert_datas(cur, list):
sql_insert_datas = 'insert into voucher(key_value) VALUES (%s)'
cur.executemany(sql_insert_datas, list)
conn.commit()
def delete_data(cur):
sql_delete_data = 'delete from voucher WHERE id = 2'
cur.execute(sql_delete_data)
conn.commit()
with conn.cursor() as cur:
result = []
for i in range(200):
st = [random.choice(all_str()) for j in range(20)]
st = ''.join(st)
result.append(st)
insert_datas(cur, result)
query_data(cur)
delete_data(cur)
新知識
多條插入時(shí)转绷，用executemany語句修然，不要使用insert_into_db中那樣的寫法徊哑，效率很低
自增的主鍵：id INT(20) not null AUTO_INCREMENT,primary key (id)
