.
.
.
【Xampp】phpMyAdmin Drop Database or Table
Xampp - phpMyAdmin Backup or export a Database
How to - Create phpMyAdmin Database or Table
In this post will shows you steps on how to create database or create single table into phpMyAdmin.
Drop - Database
1 - Drop Database Using Drop Function.
First open up your phpMyAdmin page(index page) for my case I am using Xampp, after you have open your phpMyAdmin page :
- Go to top navigation bar,click the database button.
- Tick the database that you want to drop.
- Click the Drop button at the bottom.
2 - Drop Database Using SQL Query.
To drop database using SQL query scroll to the bottom if needed, at the bottom you will see a Console button click the console button and type in :
DROP DATABASE `testdb`;
replace the red text to your database name, and press Ctrl+Enter key to execute.
replace the red text to your database name, and press Ctrl+Enter key to execute.
Drop - Table
Method - 1
Method - 2
1 - Drop Table Using Drop Function.
First open up the database that consist the table that your want to drop.
Method - 1
To drop single table, just click on the drop button of that row of table you want to drop, after that it will prompt your a confirmation dialog just click OK.
Method - 2
To drop multiple table at the same time :
- Tick all the table that you want to drop.
- Click on the dropdown list.
- Select Drop from the list.
2 - Drop Table Using SQL Query.
To drop table using SQL query scroll to the bottom if needed, at the bottom you will see a Console button click the console button and type in :
DROP TABLE `account`
replace the red text to your table name, and press Ctrl+Enter key to execute.
replace the red text to your table name, and press Ctrl+Enter key to execute.
Subscribe
0 Comments