pip install oursql
python
import oursql
python
conn = oursql.connect(
host='localhost',
user='root',
passwd='password',
db='database_name'
)
python
cursor = conn.cursor(oursql.DictCursor)
cursor.execute("SELECT * FROM table_name")
rows = cursor.fetchall()
python
data = {
'column1': 'value1',
'column2': 'value2',
'column3': 'value3'
}
cursor = conn.cursor()
cursor.execute("INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)", list(data.values()))
conn.commit()
python
data = {
'column1': 'new_value1',
'column2': 'new_value2',
'column3': 'new_value3'
}
cursor = conn.cursor()
cursor.execute("UPDATE table_name SET column1=?, column2=?, column3=? WHERE condition", list(data.values()))
conn.commit()
python
condition = 'some_condition'
cursor = conn.cursor()
cursor.execute("DELETE FROM table_name WHERE condition", condition)
conn.commit()
python
conn.close()
