python mysql 取余运算符_使用％s运算符在Python中创建MySQL数据库

Trying to create a database where the name is given through the %s operator.

import mysql.connector, MySQLdb

db_name='SomeString'

#create connection to mysql

mydb=mysql.connector.connect(host="localhost",user="root")

#init cursor

mycursor=mydb.cursor()

#create database

mycursor.execute("CREATE DATABASE (%s)", (db_name))

This is the error msg:

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(%s)' at line 1

解决方案

I think you are intending the value of db_name to be inserted instead of the %s, like a placeholder in C. This doesn't work as you have found out. Instead, you could do something like:

create_statement = "CREATE DATABASE {:s}".format(db_name)

mycursor.execute(create_statement)

Doing it this way will allow you to use the technique in more complex situations where there is more SQL after the value you are trying to substitute.