斜杠插入mysql数据库出错

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 使用参数化查询插入数据
path = "/some/path/with/slashes"
query = "INSERT INTO your_table (path_column) VALUES (%s)"
cursor.execute(query, (path,))

db.commit()
cursor.close()
db.close()

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 手动转义特殊字符
path = "/some/path/with/slashes"
escaped_path = mysql.connector.escape_string(path)
query = f"INSERT INTO your_table (path_column) VALUES ('{escaped_path}')"

cursor.execute(query)
db.commit()
cursor.close()
db.close()

import re

# 示例路径
path = "/some/path/with/slashes"

# 使用不同的定界符
pattern = r'(?i)\bpath\b'  # 使用\b作为单词边界，避免与斜杠冲突
match = re.search(pattern, path)
if match:
    print("Path contains 'path'")
else:
    print("Path does not contain 'path'")