python import oursql conn = oursql.connect(host='localhost', port=3306, user='root', passwd='password', db='mydatabase') python cur = conn.cursor() cur.execute("SELECT * FROM mytable") result = cur.fetchall() for row in result: print(row) python cur.execute("INSERT INTO mytable (name, age) VALUES (?, ?)", ['John Doe', 25]) cur.execute("UPDATE mytable SET age=? WHERE name=?", [30, 'John Doe']) cur.execute("DELETE FROM mytable WHERE name=?", ['John Doe']) conn.commit() python cur.close() conn.close()