瀹夎渚濊禆搴?br data-filtered="filtered" />
浣跨敤 pip 鏉ュ畨瑁?mysql-connector-python錛岃繖鏄竴涓敤浜庝笌 MySQL 鏁版嵁搴撲氦浜掔殑 Python 椹?br data-filtered="filtered" />
鍔ㄧ▼搴忋€?br data-filtered="filtered" />
bash
pip install mysql-connector-python
榪炴帴鏁版嵁搴?br data-filtered="filtered" />
python
import mysql.connector
# 榪炴帴鍒?MySQL 鏁版嵁搴?br data-filtered="filtered" />
mydb = mysql.connector.connect(
host="localhost", # 鏁版嵁搴撲富鏈哄湴鍧€
user="yourusername", # 鏁版嵁搴撶敤鎴峰悕
password="yourpassword", # 鏁版嵁搴撳瘑鐮?br data-filtered="filtered" />
database="yourdatabase" # 鏁版嵁搴撳悕縐?br data-filtered="filtered" />
)
鎵ц SQL 鏌ヨ
# 鍒涘緩涓€涓父鏍囧璞★紝閫氳繃瀹冩垜浠彲浠ユ墽琛?SQL 鍛戒護
mycursor = mydb.cursor()
# 鎵ц SQL 鏌ヨ璇彞
mycursor.execute("SELECT * FROM yourtable")
# 鑾峰彇鏌ヨ緇撴灉騫舵墦鍗板嚭鏉?br data-filtered="filtered" />
results = mycursor.fetchall()
for x in results:
print(x)
鎻掑叆鏁版嵁
python
# 鍒涘緩涓€涓柊鐨勮褰?br data-filtered="filtered" />
mycursor.execute("INSERT INTO yourtable (column1, column2) VALUES (%s, %s)", ("value1",
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
