数据库操作：Python连接MySQL数据库并进行CRUD操作的示例。

原创本是古典何须时尚 2024-12-31 15:45 20阅读 0赞

首先，你需要安装`mysql-connector-python`库来连接MySQL数据库。你可以使用pip来安装：

```bash
pip install mysql-connector-python
```

以下是一个简单的Python脚本，展示如何连接到MySQL数据库，执行 CRUD 操作。

```python
import mysql.connector

# 创建数据库连接
def connect_to_db():
    connection = mysql.connector.connect(
        host="localhost",  # 或你的MySQL服务器地址
        user="your_username",  # 这里替换为你的用户名
        password="your_password",  # 这里替换为你的密码
        database="your_database"  # 这里替换为你想要使用的数据库名称
    )
    return connection

# 创建、读取、更新和删除数据的示例
def perform_crud_operations():
    connection = connect_to_db()

if connection.is_connected():
        print("Connected to MySQL database")

# 创建数据 (INSERT)
        create_user_data = """
        INSERT INTO users (username, password)
        VALUES (%s, %s)
        """
        user_data = ("John Doe", "password123"))
        cursor = connection.cursor()
        cursor.execute(create_user_data, user_data))
        print("User created successfully")

# 读取数据 (SELECT)
        read_user_data = """
        SELECT * FROM users WHERE username=%s;
        """
        cursor.execute(read_user_data, ("John Doe",))))
        result = cursor.fetchall()
        if result:
            print("User data fetched successfully:")
            for row in result:
                print(row)
        else:
            print("No user data found")

# 更新数据 (UPDATE)
        update_user_password = """
        UPDATE users SET password=%s WHERE username=%s;
        """
        updated_password = ("newpassword123", "John Doe"))
        cursor.execute(update_user_password, updated_password))
        print("User password updated successfully")

# 删除数据 (DELETE)
        delete_user = """
        DELETE FROM users WHERE username=%s;
        """
        to_delete = ("John Doe",))
        cursor.execute(delete_user, to_delete))
        print("User deleted successfully")

connection.commit()  # 提交更改
        connection.close()  # 关闭连接

else:
        print("Connection failed")

perform_crud_operations()
```

注意：请将上述代码中的`your_username`、`your_password`和`your_database`替换为你自己的MySQL数据库信息。