Python MySQL Kufaa Taabu
- Sehemu ya Kupya Zaidi MySQL Kufaa Taabu
- Pya Zaidi 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)
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)
- Sehemu ya Kupya Zaidi MySQL Kufaa Taabu
- Pya Zaidi MySQL Kufaa Taabu