pymysql简单使用

```python
# encoding:utf-8

import pymysql

# db = pymysql.connect(
#     host = '127.0.0.1',
#     user = 'root',
#     password = '123456',
#     database = 'pymysql',
#     port = 3306
# )
# cursor =db.cursor()
# cursor.execute('select * from poems')
# request = cursor.fetchone()
# print(request)
# db.close()

conn = pymysql.connect(
    host = '127.0.0.1',
    user = 'root',
    password = '123456',
    database = 'pymysql',
    port = 3306
)


cursor = conn.cursor()
sql= '''insert into poems (id ,title,dynasty,author,contont) VALUES (DEFAULT ,%s,%s,%s,%s)'''

title = '论诗三十首·其四'
dynasty= '金朝'
author = '元好问'
contont = '''
一语天然万古新，豪华落尽见真淳。
南窗白日羲皇上，未害渊明是晋人。
'''

cursor.execute(sql,(title,dynasty,author,contont))
conn.commit()

cursor.close()