pip install pymysql
python
import pymysql
python
conn = pymysql.connect(host='localhost', user='your_user', password='your_password', db='your_database')
python
cursor = conn.cursor()
cursor.execute('SELECT * FROM your_table')
results = cursor.fetchall()
for row in results:
print(row)
python
conn.close()
python
import pymysql
conn = pymysql.connect(host='localhost', user='your_user', password='your_password', db='your_database')
cursor = conn.cursor()
cursor.execute('SELECT * FROM your_table')
results = cursor.fetchall()
for row in results:
print(row)
conn.close()