import pymysql

host='localhost'

user='root'

passwd='root'

port=3306

db='test'

db=pymysql.connect(

    host=host,

    user=user,

    passwd=passwd,

    db=db,

    port=port,

    charset='utf8',

    cursorclass = pymysql.cursors.DictCursor

)

cursor=db.cursor()

sql="select * from documents"

try:

    cursor.execute(sql)

    result=cursor.fetchall()

    for i in result:

        for j in i:

            print(j,"=>",i[j])

            print(" ")

except:

    print('error')

db.close()