微信小程序:数据库:python连接
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录前一修订版 | |||
| 微信小程序:数据库:python连接 [2023/11/23 09:43] – bjgdtc | 微信小程序:数据库:python连接 [2023/11/23 09:44] (当前版本) – bjgdtc | ||
|---|---|---|---|
| 行 1: | 行 1: | ||
| python.exe -m pip install –upgrade pip | python.exe -m pip install –upgrade pip | ||
| + | < | ||
| import mysql.connector | import mysql.connector | ||
| - | < | ||
| connection = mysql.connector.connect( | connection = mysql.connector.connect( | ||
| - | </ | ||
| - | |||
| - | < | ||
| host='', | host='', | ||
| - | </ | ||
| - | |||
| - | < | ||
| user='', | user='', | ||
| - | </ | ||
| - | |||
| - | < | ||
| password='', | password='', | ||
| - | </ | ||
| - | |||
| - | < | ||
| database='' | database='' | ||
| - | </ | ||
| - | |||
| - | < | ||
| ) | ) | ||
| - | </ | ||
| - | |||
| - | < | ||
| if connection.is_connected(): | if connection.is_connected(): | ||
| - | </ | ||
| - | |||
| - | < | ||
| cursor = connection.cursor() | cursor = connection.cursor() | ||
| - | </ | ||
| - | |||
| - | < | ||
| sql_query = "SHOW TABLES;" | sql_query = "SHOW TABLES;" | ||
| - | </ | ||
| - | |||
| - | < | ||
| cursor.execute(sql_query) | cursor.execute(sql_query) | ||
| - | </ | ||
| - | |||
| - | < | ||
| tables = cursor.fetchall() | tables = cursor.fetchall() | ||
/www/wwwroot/dokuwiki/data/attic/微信小程序/数据库/python连接.1700703825.txt.gz · 最后更改: 2023/11/23 09:43 由 bjgdtc