Question 21362 in Mysql Question posted in
The official MySQL documentation can be found here.

i cant use python input to create mysql database

I want to take input from user of creating a mysql database I cant use python input to create mysql databasewhat i tryed

Getting this error please help the error

Tags:

2

Answers


  1. 0

    execute() method parameters must be provided as a tuple, dict or a list :

    cursor.execute(cdb, (dbname,))

    And I think you can execute your query directly like :

    %-formatting

    cdb = 'CREATE DATABASE %s' % dbname 
cursor.execute(cdb)

    F-strings

    cdb = f'CREATE DATABASE {dbname}'
cursor.execute(cdb)

    str.format()

    cdb = 'CREATE DATABASE {}'.format(dbname) 
cursor.execute(cdb)

    Consider using f-strings when dealing with string that contains variables.

    cdb = f'CREATE DATABASE {dbname}'
    Login or Signup to reply.
  2. 0

    Try this way, this works correctly.

    try:import mysql.connector as con
except ImportError:print("⚠ Install correctly mysql.connector")

db = con.connect(host="localhost",user="<username>",passwd="<password>")
cursor = db.cursor()

dbname = input("Enter ddbb name to create: ")
cdb = f"CREATE DATABASE {dbname}"

try:cursor.execute(cdb)
except NameError:print(NameError)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search