pymysql交互查询

代码一

# This is a sample Python script.

# Press Shift+F10 to execute it or replace it with your code.
# Press Double Shift to search everywhere for classes, files, tool windows, actions, and settings.
import pymysql


#1.建立连接（客户端连接服务端）
conn = pymysql.connect(
    host='',
    port=3306,
    user='root',
    password='',
    database='',
    charset='utf8'  #不带-
)


#2.创建数据库访问的游标
cursor = conn.cursor(pymysql.cursors.DictCursor)
cursor = conn.cursor()

#插入数据的函数
def insert(sql):
    #3.执行SQL语句
    cursor.exexute(sql)
    #4.向数据苦衷提交数据
    conn.commit()


#调用函数
# insert("insert into digital_image(id,image_name,image_upload_time,image_code,image_url,image_mode,image_level,image_file_id) value ()")
sql = "select * from digital_image;"

def searchALL(sql):
    cursor.execute(sql)
    records = cursor.fetchall()
    for record in records:
        print(record[1])



#关闭数据库连接
def closeDB():
    conn.close()


def print_hi(name):
    # Use a breakpoint in the code line below to debug your script.
    print(f'Hi, {name}')  # Press Ctrl+F8 to toggle the breakpoint.

# Press the green button in the gutter to run the script.
if __name__ == '__main__':
    print_hi('PyCharm')
    searchALL(sql)
    closeDB()

# See PyCharm help at https://www.jetbrains.com/help/pycharm/