在Python中调用MySQL存储过程,你可以使用`mysql-connector-python`库。以下是一个简单的示例,展示了如何调用存储过程:
1. 安装`mysql-connector-python`库:
```bash
pip install mysql-connector-python
2. 连接到MySQL数据库:
```python
import mysql.connector
cnx = mysql.connector.connect(
host="localhost",
user="your_username",
password="your_password",
database="your_database"
)
3. 创建存储过程(如果尚未创建):
```python
def create_procedure():
cursor = cnx.cursor()
query = """
CREATE PROCEDURE get_users_by_age(IN min_age INT, IN max_age INT)
BEGIN
SELECT * FROM users WHERE age BETWEEN min_age AND max_age;
END
"""
cursor.execute(query)
cursor.close()
4. 调用存储过程:
```python
def call_procedure(min_age, max_age):
cursor = cnx.cursor()
cursor.callproc("get_users_by_age", (min_age, max_age))
results = cursor.fetchall()
for row in results:
print(row)
cursor.close()
5. 关闭数据库连接:
```python
cnx.close()
请确保在调用存储过程之前已经创建了相应的数据库和表,并且存储过程已经在数据库中定义好了。