how to clean everything in mysql db

  • phpMyAdmin -> select the db to be empty -> structure -> check all -> [with selected:] -drop
    • The easiest way to empty a MySQL database is through phpMyAdmin
    • Once in phpMyAdmin, select the database you wish to empty.
    • A list with all the database’s tables will appear. Click [Check All] to select all tables.
    • Click the box [With selected:] and choose Drop and confirm. This will execute the DROP TABLE SQL query on all tables and the database will be emptied.
  • by SQL
Advertisements
This entry was posted in DB. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s