水月笔记

python.exe -m pip install –upgrade pip

import mysql.connector

connection = mysql.connector.connect(

host='',

user='',

password='',

database=''

)

if connection.is_connected():

    cursor = connection.cursor()

    sql_query = "SHOW TABLES;"

    cursor.execute(sql_query)

    tables = cursor.fetchall()