pip install oursql
python
import oursql
python
conn = oursql.connect(host='localhost', user='username', passwd='password', db='database')
python
cursor = conn.cursor()
cursor.execute("CREATE INDEX index_name ON table(column)")
python
cursor = conn.cursor()
cursor.executemany("INSERT INTO table(column1, column2) VALUES(?, ?)", data)
conn.commit()
python
cursor = conn.cursor(prepared=True)
cursor.execute("SELECT * FROM table WHERE column = ?", (value,))
python
cursor = conn.cursor()
cursor.execute("SELECT * FROM table LIMIT ?, ?", (offset, limit))
