主页
Python
Python MySQL Drop Table 语句
demo_mysql_drop_table
运行 ❯
×
更改方向
保存代码
更改主题
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="myusername", password="mypassword", database="mydatabase" ) mycursor = mydb.cursor() sql = "DROP TABLE customers" mycursor.execute(sql) #If this page was executed with no error(s), you have successfully deleted the "customers" table.
C:\Users\My Name>python demo_mysql_drop_table.py