import pymysql
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydb')
cursor = conn.cursor()
cursor.execute("SELECT * FROM mytable")
result = cursor.fetchall()
cursor.close()
conn.close()
import pymysql
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydb')
conn.begin()
cursor = conn.cursor()
sql1 = "INSERT INTO mytable (column1, column2) VALUES (%s, %s)"
sql2 = "UPDATE mytable SET column1 = %s WHERE column2 = %s"
data = [('value1', 'value2'), ('value3', 'value4')]
cursor.executemany(sql1, data)
cursor.executemany(sql2, data)
conn.commit()
cursor.close()
conn.close()
python
import pymysql
from DBUtils.PooledDB import PooledDB
pool = PooledDB(pymysql, host='localhost', port=3306, user='root', password='password', db='mydb')
conn = pool.connection()
cursor = conn.cursor()
cursor.execute("SELECT * FROM mytable")
result = cursor.fetchall()
cursor.close()
conn.close()
python
import pymysql
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydb')
cursor = conn.cursor()
cursor.execute("CREATE INDEX idx_column1 ON mytable (column1)")
cursor.close()
conn.close()
python
import pymysql
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydb')
cursor = conn.cursor(pymysql.cursors.DictCursor)
sql = "INSERT INTO mytable (column1, column2) VALUES (%s, %s)"
data = [('value1', 'value2'), ('value3', 'value4')]
cursor.executemany(sql, data)
conn.commit()
cursor.close()
conn.close()
