So what is the boring part of the Developing a Web app? Testing!! yeah! Build a test case and then for each case clean up the database and re-create one. Doing this every time blown up anyone's mind. For some relief, MySql workbench does the synchronization of database fast. But still dropping all the table from phpMyAdmin MySQL database is a headache. Can we do it with just a couple of clicks? Yeah sure! you just need to write a couple of batch programs and execute them in a sequence. So, Let's do that!! We should begin with dropping all the tables and views from the database. Open Notepad or Notepad++ Then write a SQL query for getting the names of all the tables from the database and a Drop query sequence for all the tables with a semicolon(;), write the code shown below and save that file with .sql extension. Write similar code for the views as shown below, Now again create a new notepad for batch code, write the code below and do
The blog represents my thoughts on life and mostly something related to web development.