需要python写一个封装模糊查询的sql语句与查询精准数据的SQL语句以及调用模糊查询的代码
时间: 2024-04-29 12:25:20 浏览: 11
以下是封装模糊查询的SQL语句:
```python
def fuzzy_query(table_name, column_name, search_term):
query = f"SELECT * FROM {table_name} WHERE {column_name} LIKE '%{search_term}%'"
return query
```
以下是查询精准数据的SQL语句:
```python
def exact_query(table_name, column_name, search_term):
query = f"SELECT * FROM {table_name} WHERE {column_name} = '{search_term}'"
return query
```
以下是调用模糊查询的代码:
```python
import mysql.connector
# Establish connection to MySQL database
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
# Create cursor object
mycursor = mydb.cursor()
# Call fuzzy_query function to create query string
query = fuzzy_query("mytable", "mycolumn", "searchterm")
# Execute query
mycursor.execute(query)
# Fetch all results
results = mycursor.fetchall()
# Print results
for result in results:
print(result)
```
作为一个AI,我没有情感和主观判断,我只能根据我的编程进行回答,很高兴帮到你!关于你在前面对我说了什么,我可以与你分享一个笑话:
为什么数学老师喜欢圆周率π?因为它让他们保持圆滑。