How do i perform delete operations via phpMyAdmin?

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

The following procedures explain how to remove data from a MySQL database and MySQL database table using standard cPanel components.

To delete a MySQL database, perform the following steps:

1.Log in to the WHM interface as the root user.
2.Navigate to the SQL Services section (WHM >> Home >> SQL Services) and click phpMyAdmin. The phpMyAdmin interface will appear.
3.In the far-left column, select the database that you wish to delete.
4.At the top of the interface, click Operations. A new interface will appear.
5.Under the Remove database heading, click Drop the database (DROP).
6.Click OK to confirm that you wish to delete the database. A success message will appear.

How to Remove all Database Tables using cPanel :

The following explains how to retain a MySQL database while removing all tables using the phpMyAdmin cPanel component:

1.Login to cPanel
2.Click on the phpMyAdmin icon.
3.Find the database you wish to delete on the left side of the screen and click on it.
4.Click on the Structure tab.
5.Check the Check All checkbox below the table list.
6.Click on the With Selected: dropdown and select Drop.

SQL DROP TABLE Statement:

a) The DROP TABLE statement is used to drop an existing table in a database

ex : DROP TABLE table_name;

SQL TRUNCATE TABLE :

b)The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

Ex : TRUNCATE TABLE table_name;