Python MySQL Kufaa Taabu

Kufaa Taabu Tablica

Inaweza kutumia heriko la "DROP TABLE" kuondoa tablica ya ndani:

Mfano

Kufaa Taabu Tablica "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)

Kumwimba Mfano

Kufaa Taabu Kwenye Tablica Inayotumika

Kama tablica inayotumika ikatoka, au inaonekana kwa sababu ya sababu nyingine, inaweza kutumia heriko la IF EXISTS kuondoa kosa.

Mfano

Kufaa Taabu "customers" (kama inahusiana):

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)

Kumwimba Mfano