PythonでMySQL操作
pipでインストール
pip install mysql-connector-python
簡易接続テスト
import mysql.connector cnx = mysql.connector.connect( user='mysql', password='YourPassword', host='localhost', database='DBName' ) cursor = cnx.cursor() query = ('SHOW TABLES') cursor.execute(query) tbls = [] for tbl in cursor: print(tbl) tbls.append(tbl) cursor.close() cnx.close()