Python MySQL Drop Tabatowa

Gudan tabatowa

Duba za ake amfani da aikace "DROP TABLE" don kaiwa tabatowa da ake hanyan:

Dabbanci

Gudan tabatowa "customers":

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DROP TABLE customers"
mycursor.execute(sql)

Labarai Dabbanci

Gudan tabatowa kawai dake

Idan tabatowa da ake ƙasa an ƙara a kaiwa ko amfani da abin IF EXISTS don yaƙi kaiwa ƙara sai. Duk amfani a kaiwa ko amfani da abin sai.

Dabbanci

Gudan tabatowa "customers" (ifi ana ana):

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DROP TABLE IF EXISTS customers"
mycursor.execute(sql)

Labarai Dabbanci