pip install MySQL-python
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database_name")
cursor = db.cursor()
query = "SELECT * FROM table_name"
cursor.execute(query)
result = cursor.fetchall()
for row in result:
print(row)
insert_query = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')"
cursor.execute(insert_query)
update_query = "UPDATE table_name SET column1='new_value' WHERE condition"
cursor.execute(update_query)
db.commit()
delete_query = "DELETE FROM table_name WHERE condition"
cursor.execute(delete_query)
db.commit()
cursor.close()
db.close()
