Python kafa ba a kafa

Kafa ba a kafa

Ga ce dona kafa ba a kafa ba a MySQL, kuma gina kala 'CREATE DATABASE':

Dabbanci

Anfani baya'ar "mydatabase":

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")

Yanwar Dabbanci

Idan a kai tsaye na kiyayya na aiki na yau ba za a samu rashin lafiya ba, za a iya gudanar da baya'ar "mydatabase".

Tsammanin baya'ar da ke cikin

Za a iya samar da dukkan baya'ar da ke cikin system da kawo aiki ga "SHOW DATABASES" da yin tsammanin baya'ar an yi:

Dabbanci

Ayyuka na dukkan baya'ar da ke cikin system:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword"
)
mycursor = mydb.cursor()
mycursor.execute("SHOW DATABASES")
for x in mycursor:
  print(x)

Yanwar Dabbanci

ko kuma za a iya kawo aiki ga baya'ar a lokacin da za a tsara rarraba:

Dabbanci

Aiki a kan kiyayya da baya'ar "mydatabase":

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

Yanwar Dabbanci

Idan baya'ar da ke cikin bayanai ba za a samu rashin lafiya ba.