Learn How To Empty a mySQL Database: 3 Methods

So you have a mySQL database that you want to empty it? No problem! It is a very easy job. In this article I will explain how to empty a mySQL database content in a simple and a quick way. 

Method 1

1. In mySQL, click on your database name.

2. Select (tick) all the tables

3. At the bottom there is a button DELETE, click it.

That's it. All content is deleted from your database tables.

Method 2:

Step 1: Open myphpadmin

Step 2: Click on the SQL tab.

Step 3: Type SQL command - DROP DATABASE ""your-database-name"" (without quotes)

This will drop all tables in your database

Method 3:

Step 1: Login as mySQL admin or root user with this command $mysql -u root -p

Step 2: Drop the database - DROP DATABASE ""your-database-name"" (without quotes)

Step 3: Now you need to recreate the database, and to do this use this command - CREATE DATABASE ""your-database-name"" (without quotes)

Step 4: Now exit and close the session

This was how to empty a mySQL database the easiest ways!

Looking for something else? search here

Related Articles

Free Joomla templates by Ltheme