python
conn = oursql.connect(user='username', passwd='password', db='database_name')
python
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
python
results = cursor.fetchall()
python
for row in results:
print(row)
python
cursor.execute("INSERT INTO table_name (column1, column2) VALUES (?, ?)", (value1, value2))
cursor.execute("UPDATE table_name SET column1 = ? WHERE column2 = ?", (new_value, condition_value))
cursor.execute("DELETE FROM table_name WHERE column = ?", (value,))
python
conn.commit()
conn.close()