Ejecutar consulta Mysql desde una funcion (Python)

from tkinter import *
from tkinter import ttk
from conexion import *

####### FUNCIONES #######

def click():
    ttk.Label(mainframe, text="Haz echo CLICK").grid(column=40, row=70, sticky=W)
    ttk.Button(mainframe, text="BOTON 2", command=click2).grid(column=40, row=90, sticky=W)

def click2():
    ttk.Label(mainframe, text="POR FIN!!").grid(column=40, row=110, sticky=W)
    ttk.Button(mainframe, text="BOTON 2").grid(column=40, row=130, sticky=W)

def crearCliente():
    crearCliente1 = "INSERT INTO test(id,name,email) VALUES ('5','prueba','prueba')"
    
    ttk.Label(mainframe, text="Haz creado un cliente").grid(column=40, row=150, sticky=W)


####### VENTANA Tkinter #######

root = Tk()
root.title("Mostrar datos")
root.geometry("400x400")

mainframe = ttk.Frame(root, padding="3 3 12 12")
mainframe.grid(column=0, row=0, sticky=(N, W, E, S))
root.columnconfigure(0, weight=1)
root.rowconfigure(0, weight=1)


ttk.Label(mainframe, text=results).grid(column=3, row=2, sticky=W)
ttk.Label(mainframe, text="Probando Label").grid(column=30, row=20, sticky=W)

ttk.Button(mainframe, text="BOTON", command=crearCliente).grid(column=40, row=40, sticky=W)



root.mainloop()

import pymysql

# Abre conexion con la base de datos
db = pymysql.connect(host='localhost',
                             user='root',
                             password='root',
                             database='test',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)
##################################################
cursor = db.cursor()

# Seleccionador base de datos
sql = "SELECT name FROM test WHERE id = 2"

# Ejecutar comando
cursor.execute(sql)

# Mostrar
results = cursor.fetchall()

# Desconexion
db.close()