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.
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.
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
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!