# -*- coding: utf-8 -*- import sys import pymysql sys.stdout.reconfigure(encoding='utf-8') c = pymysql.connect(host='123.60.180.165', port=3306, user='aidopremote', password='1234567890aiDOP#', database='information_schema', charset='utf8mb4') cur = c.cursor() for db in ['aidopdev', 'dopdemo']: cur.execute("SELECT TABLE_NAME FROM tables WHERE TABLE_SCHEMA=%s AND TABLE_NAME IN ('sys_menu','SysMenu','sys_Menu','sys_tenant','sys_role','sys_user')", (db,)) print(f"[{db}]", cur.fetchall()) cur.execute("SELECT TABLE_NAME FROM tables WHERE TABLE_SCHEMA=%s AND TABLE_NAME LIKE '%menu%'", (db,)) print(f"[{db}] menu-like:", cur.fetchall()) cur.close(); c.close()