bash
pip install oursql
python
import oursql
python
conn = oursql.connect(host='localhost', user='username', passwd='password', db='database_name')
python
cursor = conn.cursor()
cursor.execute("SELECT * FROM table_name")
python
python
cursor.execute("INSERT INTO table_name (column1, column2) VALUES (%s, %s)", ('value1', 'value2'))
cursor.execute("UPDATE table_name SET column1 = %s WHERE condition", ('new_value',))
cursor.execute("DELETE FROM table_name WHERE condition")
python
conn.commit()
python
conn.close()
