Python MariaDB – Drop Table using PyMySQL
Last Updated :
14 Oct, 2020
MariaDB is an open source Database Management System and its predecessor to MySQL. The pymysql client can be used to interact with MariaDB similar to that of MySQL using Python.
In this article we will look into the process of Dropping a table from a database using pymysql. To drop a table use any of the below syntax:
Syntax :
DROP TABLE tablename;
DROP TABLE IF EXISTS tablename;
The following programs will help you understand this better.
Example 1 :
Program to demonstrate drop if exists. We will try to drop a table which does not exist in the above database.
Python3
import pymysql
Host = "localhost"
User = "user"
Password = ""
database = "GFG"
conn = pymysql.connect(host = Host, user = User, password = Password, database)
cur = conn.cursor()
query = f "DROP TABLE IF exists Employee"
cur.execute(query)
conn.close()
|
Output :
Example 2 :
Here we will drop the student table.
Python3
import pymysql
conn = pymysql.connect( 'localhost' , 'user' , 'password' , 'database' )
cur = conn.cursor()
query = f "DROP TABLE IF exists Student"
cur.execute(query)
rows = cur.fetchall()
conn.close()
for row in rows :
print (row)
|
Output :
Share your thoughts in the comments
Please Login to comment...