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()


上一篇:
下一篇:
切换中文