如何使用python操作MySQL数据库

**使用Python操作MySQL数据库**

在现代软件开发中，数据库是数据存储和管理的关键组成部分。MySQL是一种流行的关系型数据库管理系统，广泛用于各种应用场景。Python作为一种强大的编程语言，可以轻松地与MySQL数据库进行交互。在本文中，我们将介绍如何使用Python操作MySQL数据库。

**安装必要库**

首先，我们需要安装两个必备的库：`mysql-connector-python`和`pymysql`。

bashpip install mysql-connector-python pymysql

import mysql.connector# MySQL数据库的配置信息config = {
 'host': 'localhost',
 'database': 'mydb',
 'user': 'root',
 'password': '123456'
}

try:
 # 建立连接 cnx = mysql.connector.connect(**config)
 print("Connected to MySQL database")
except mysql.connector.Error as err:
 print(f"Error connecting to MySQL database: {err}")

# 创建表cursor = cnx.cursor()
query = "CREATE TABLE users (id INT AUTO_INCREMENT, name VARCHAR(255), email VARCHAR(255), PRIMARY KEY(id))"
try:
 cursor.execute(query)
except mysql.connector.Error as err:
 print(f"Error creating table: {err}")

# 插入数据query = "INSERT INTO users (name, email) VALUES (%s, %s)"
data = ('John Doe', 'john@example.com')
try:
 cursor.execute(query, data)
except mysql.connector.Error as err:
 print(f"Error inserting data: {err}")

# 查询数据query = "SELECT * FROM users"
try:
 cursor.execute(query)
 result = cursor.fetchall()
 for row in result:
 print(row)
except mysql.connector.Error as err:
 print(f"Error querying data: {err}")

# 更新数据query = "UPDATE users SET name = %s WHERE id = %s"
data = ('Jane Doe',1)
try:
 cursor.execute(query, data)
except mysql.connector.Error as err:
 print(f"Error updating data: {err}")

# 删除数据query = "DELETE FROM users WHERE id = %s"
data = (1,)
try:
 cursor.execute(query, data)
except mysql.connector.Error as err:
 print(f"Error deleting data: {err}")

cnx.close()
print("Disconnected from MySQL database")