删除表,如果存在。
删除表,如果存在。详细操作教程
以下实例为学习删除表,如果存在。,具体代码如下:
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="myusername",
passwd="mypassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DROP TABLE if EXISTS customers"
mycursor.execute(sql)
#if this page was executed with no error(s), you have successfully deleted the "customers" table.
执行以上代码输出结果为:
# Filename : example.py
# Author by : www.lidihuo.com