建站
咨詢
售后
建站咨詢
新聞中心
要使用Python連接MySQL數(shù)據(jù)庫(kù)，你需要按照以下步驟操作：
1、安裝MySQL Connector/Python
2、導(dǎo)入mysql.connector模塊
3、創(chuàng)建數(shù)據(jù)庫(kù)連接
4、創(chuàng)建游標(biāo)對(duì)象
5、執(zhí)行SQL查詢
6、獲取查詢結(jié)果
7、關(guān)閉游標(biāo)和數(shù)據(jù)庫(kù)連接
下面是詳細(xì)的步驟和代碼示例：
1. 安裝MySQL Connector/Python
在命令行中輸入以下命令來(lái)安裝MySQL Connector/Python：
pip install mysqlconnectorpython
2. 導(dǎo)入mysql.connector模塊
在你的Python腳本中，導(dǎo)入mysql.connector模塊：
import mysql.connector
3. 創(chuàng)建數(shù)據(jù)庫(kù)連接
使用mysql.connector.connect()方法創(chuàng)建一個(gè)到MySQL服務(wù)器的連接，需要提供數(shù)據(jù)庫(kù)的地址、用戶名、密碼和數(shù)據(jù)庫(kù)名：
cnx = mysql.connector.connect(
host="localhost",
user="your_username",
password="your_password",
database="your_database"
)
4. 創(chuàng)建游標(biāo)對(duì)象
使用游標(biāo)對(duì)象來(lái)執(zhí)行SQL查詢并獲取結(jié)果：
cursor = cnx.cursor()
5. 執(zhí)行SQL查詢
使用游標(biāo)對(duì)象的execute()方法執(zhí)行SQL查詢，要查詢名為employees的表中的所有數(shù)據(jù)，可以執(zhí)行以下查詢：
query = "SELECT * FROM employees" cursor.execute(query)
6. 獲取查詢結(jié)果
使用游標(biāo)對(duì)象的fetchall()方法獲取查詢結(jié)果：
results = cursor.fetchall()
for row in results:
print(row)
7. 關(guān)閉游標(biāo)和數(shù)據(jù)庫(kù)連接
在完成所有操作后，關(guān)閉游標(biāo)和數(shù)據(jù)庫(kù)連接：
cursor.close() cnx.close()
將以上代碼整合到一個(gè)Python腳本中，完整的示例如下：
import mysql.connector
import sys
from datetime import date, timedelta, datetime, timezone, pytz, DSTInfo, time as ttime, mktime, localtime, strftime, asctime, gmtime, struct_time, altzone, daylight, isdst, clock_gettime, timezone as timetz, ctime, sleep, getcwday, getweekday, getpasswd, getuser, getgrgid, getgrnam, getpwnam, getservbyname, getservbyport, gethostbyname, gethostbyaddr, gethostname, urandom, socket, select, errno, fcntl, ioctl, termios, tty, ossaudiodev, resource, grp, pwd, spwd, syslog, urllib.request, urllib.parse, urllib.error, urlopen, base64, binascii, hashlib, hmac, zlib, ssl, bz2, tarfile, tempfile, random, math, copyreg, signal, statistics as statitics, itertools as itertoolsmodule, operator as operatormodule, string as stringmodule, re as remodule, json as jsonmodule; print("Hello World") # For demonstration purposes only remove before using the script!""")# Import required module for Python SQL connector (pymysql) and other modules from standard library (sys)# Create a connection to the local host's MySQL server using the credentials provided below# The default database will be used if not specified in the connection string# Note that you may need to change the login credentials depending on your setup# For example: host='localhost', user='root', password='mypassword'cnx = mysql.connector.connect(host="localhost", user="your_username", password="your_password", database="your_database")# Create a new cursor object using the connection above# The cursor object is used to execute SQL queries and fetch results# Note that we pass 'dictionary=True' as an argument to the cursor object creation to enable result set fetching in dictionary format# This can be useful when working with large result sets# For example: cnx = mysql.connector.connect(...), cursor = cnx.cursor(dictionary=True)cursor = cnx.cursor(dictionary=True)# Execute a simple SQL query to select all records from the 'employees' table# You can replace this query with any other valid SQL query of your choicequery = "SELECT * FROM employees"cursor.execute(query)# Fetch all rows from the result set and print them one by one# Note that we are using a for loop to iterate over the rows returned by the fetchall() methodresults = cursor.fetchall()for row in results:print(row)# Close the cursor and connection objects once done# This is important to free up system resources and prevent memory leaks# Note that you should always close these objects in reverse order of their creation# For example: cnx.close(), cursor.close()cursor.close()cnx.close()if __name__ == '__main__':pass""")# End of script
本文名稱：如何用python使用mysql數(shù)據(jù)庫(kù)
文章出自：http://m.fisionsoft.com.cn/article/ccdijsh.html
