如何使用Python自动运行MySQL数据库进行两张表的比对，如有一致则比中弹屏

以下是使用Python自动运行MySQL数据库进行两张表的比对并弹屏的步骤：

1. 安装必要的Python库：`mysql-connector-python`和`tkinter`

   pip install mysql-connector-python
   sudo apt-get install python3-tk

2. 连接到MySQL数据库并查询两张表

   import mysql.connector
   
   # 连接到MySQL数据库
   mydb = mysql.connector.connect(
       host="localhost",
       user="yourusername",
       password="yourpassword",
       database="yourdatabase"
   )
   
   # 查询两张表
   cursor1 = mydb.cursor()
   cursor1.execute("SELECT * FROM table1")
   results1 = cursor1.fetchall()
   
   cursor2 = mydb.cursor()
   cursor2.execute("SELECT * FROM table2")
   results2 = cursor2.fetchall()

3. 比较两张表的数据

   # 将结果转换为集合
   set1 = set(results1)
   set2 = set(results2)
   
   # 比较两个集合是否相等
   if set1 == set2:
       print("Tables are the same")
   else:
       print("Tables are different")

4. 弹出一个对话框

   import tkinter as tk
   from tkinter import messagebox
   
   # 创建一个Tkinter窗口
   root = tk.Tk()
   root.withdraw()
   
   # 弹出一个对话框
   messagebox.showinfo("Result", "Tables are the same")

将以上代码整合起来，得到完整的代码如下：

import mysql.connector
import tkinter as tk
from tkinter import messagebox

# 连接到MySQL数据库
mydb = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

# 查询两张表
cursor1 = mydb.cursor()
cursor1.execute("SELECT * FROM table1")
results1 = cursor1.fetchall()

cursor2 = mydb.cursor()
cursor2.execute("SELECT * FROM table2")
results2 = cursor2.fetchall()

# 将结果转换为集合
set1 = set(results1)
set2 = set(results2)

# 比较两个集合是否相等
if set1 == set2:
    print("Tables are the same")
    # 创建一个Tkinter窗口
    root = tk.Tk()
    root.withdraw()
    # 弹出一个对话框
    messagebox.showinfo("Result", "Tables are the same")
else:
    print("Tables are different")