mysql插入数据库有单引号

INSERT INTO table_name (column_name) VALUES ('It''s a test.');

INSERT INTO table_name (column_name) VALUES ("It's a test.");

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

sql = "INSERT INTO table_name (column_name) VALUES (%s)"
val = ("It's a test.",)

mycursor.execute(sql, val)
mydb.commit()

import mysql.connector

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

# 创建游标对象
mycursor = mydb.cursor()

# 准备SQL语句和数据
sql = "INSERT INTO customers (name) VALUES (%s)"
data = ("O'Reilly",)

# 执行SQL语句
mycursor.execute(sql, data)

# 提交更改
mydb.commit()

print(mycursor.rowcount, "record inserted.")