python
pip install psycopg2
python
pip install mysqlclient
python
pip install pyodbc
python
import psycopg2
config = {
'host': 'localhost',
'database': 'mydb',
'user': 'myuser',
'password': 'mypassword'
}
conn = psycopg2.connect(**config)
cur = conn.cursor()
cur.execute('SELECT * FROM mytable')
for row in cur.fetchall():
print(row)
cur.close()
conn.close()
python
import MySQLdb
config = {
'host': 'localhost',
'database': 'mydb',
'user': 'myuser',
'passwd': 'mypassword'
}
conn = MySQLdb.connect(**config)
cur = conn.cursor()
cur.execute('SELECT * FROM mytable')
for row in cur.fetchall():
print(row)
cur.close()
conn.close()
python
import pyodbc
config = {
'Driver': 'ODBC Driver 17 for SQL Server',
'Server': 'localhost',
'Database': 'mydb',
'UID': 'myuser',
'PWD': 'mypassword'
}
conn = pyodbc.connect(**config)
cur = conn.cursor()
cur.execute('SELECT * FROM mytable')
for row in cur.fetchall():
print(row)
cur.close()
conn.close()
