1. Install the PyMySQL library using pip:
pip install PyMySQL
2. Import the PyMySQL library in your Python script:
import pymysql
3. Connect to a MySQL database:
conn = pymysql.connect(host=”localhost”, user=”username”, password=”password”, db=”database_name”)
4. Create a cursor object to execute queries:
cur = conn.cursor()
5. Execute the query:
cur.execute(„SELECT * FROM table_name”)
6. Fetch the results:
rows = cur.fetchall()
7. Close the connection:
conn.close()
Legutóbbi hozzászólások