How to completely empty Truncate MySQL table in phpmyadmin

How to delete all records from MySQL table in phpmyadmin.

Truncate MySQL command is applied to erase all the elements of tables like all the records. This command is used with table name with specific database name. This command delete all the table records and make the table into by-default stage just like as after created time. After emptying the MySQL database table it will remove rows + columns all records.

On phpmyadmin's MySQL server you can truncate table by selecting Empty option on it. The step by step guide to delete records from MySQL database table.

Erasing all table records with one click using phpmyadmin in xampp.

1. First start apace & MySQL server from phpmyadmin control panel.

2. Visit localhost/phpmyadmin on your web browser.

3. Now select your Database >> Select Table.

4. Click on Empty button which is shows at the front of table name.

5. Now your will show a alert message " You are about to TRUNCATE a complete table ! Do you really want to execute  TRUNCATE tableName."

How to directly insert values on MySQL database through phpmyadmin

There are two various type of methods present on web development area to store values on MySQL database. First one is to insert from html text forms and other is directly throw information through phpmyadmin control panel area. Phpmyadmin gives us the facility to add values directly into MySQL db tables ( Rows, Columns ).

Where can i need this type of information add functionality.

The basic intention to add outright data into MySQL db is where you have to define login -functionality on your php website. With the help of pre-define data in database you can set login username and password straight. So after login from login form it will automatically check username and password key.

Add directly value on MySQL db tables using phpmyadmin.

1. Start Apache & MySQL server from xampp control panel.

2. Open localhost/phpmyadmin in your web browser.

3. Select your MySQL database -> Select Table by clicking on table name ( In which you want to insert data. ).

4. Click on Insert tab.

5. After that your table structure will be open, Just enter the values in table using given forms then click on Go button.

Conformation message after successfully information submission is " 1 Row inserted. "

How to delete MySQL database & tables in phpmyadmin Xampp

Deleting a complete MySQL database including Tables in Xampp server.

Phpmyadmin supports extreme powerful database management system MySQL. You can create hundreds of database, tables on phpmyadmin MySQL server as your development project purpose, there are no limitation. But after developing one by one web applications occasionally your phpmyadmin MySQL database panel become full and list of databases is too long so each time you have to scroll down and find your database.

Why Drop ( Delete ) MySQL database is important.

A web developer works too hard to design and develop web applications. Some rare times new developer creates lots of databases to test their developed project using phpmyadmin. But if you increase the database amount regularly and dose not use them so phpmyadmin MySQL server slowly slowly takes more time then usual starting time because every startup time it will re-configured all the MySQL database, tables. So do not create multiple database, you can create multiple table in a database as per your project requirement.

How to remove a complete MySQL database from xampp's phpmyadmin.

The process of removing a database is very easy there are no need to give a written command to phpmyadmin control panel. You can delete a complete database including its tables so no one will ever find out your database details.

1. Start XAMPP control panel.

2. Start Apache & MySQL server.

3. Open MySQL server using phpmyadmin by opening localhost/phpmyadmin in your web browser.

4. Select your database ( Witch you want to delete ) by clicking on its name.

5. Click on Operations.

6. Click on Drop the database ( DROP ).

7. Now it will show you a alert dialog message box " You are about to destroy a complete database !  Do you really want to execute DatabaseName ?" Click on OK button to delete database.

How to delete single MySQL tables in PHPMYADMIN in xampp.

1. Follow the above 1 to 5th number process same.

2. After selecting your database ( In which you want to delete tables ) all tables list will be displayed on your phpmyadmin server panel.

3. Click on Drop icon.

4. Now it will show you a alert message " You are about to DESTROY a complete table! Do you really want to execute DROP TableName ?" Click on OK button to delete single table.

How to Select & Delete Multiple MySQL tables in xampp.

You can also delete multiple MySQL tables by selecting them together with the use of check box selection method.

1. Follow the above 1st and 2nd step.

2. Checked the check box ( Which is present at the front of table name. You can select multiple tables from here by selecting them ).

3. Subsequently click on drop down menu shown as With Selected .

4. Select DROP from drop down menu.

5. Follow the next window and delete your selected table.

How to create MySQL database & tables using phpmyadmin

What is MySQL database.

Full form of MySQL is my structured query language. MySQL is open source database management system used by millions of websites, applications, software to store their data in it. Database is a place where all the text format information collect on a single location in Tabular format. MySQL database hold most useful position on dynamic web application development scope.

Why MySQL database is extremely important in php development ?

Because dynamic php websites invoke all of there text statements from MySQL database each & every time web page reloads. Absence of database, web server can not serve dynamic content. Every database contain tables. Tables are the combination of rows and columns. There are thousands of tables in a database and everyone of them endue rows + columns structure to hold the information. Every part of information is saved on columns.

How to create MySQL database in phpmyadmin.

1. The primarily step to create database is Install XAMPP APACHE SERVER so read my guide for installation.

2. After completing installation and stat the Apache & MySQL server open your web browser.

3. Type localhost/phpmyadmin in the url bar then press enter.

4. Click on New.

5. Enter your database name then click on Create button.

6. After press Create button you will see a message " Database YourDatabaseName has been created ".

-

To Open your existing database in PHPMYADMIN exclusively click on it.

Creating tables in phpmyadmin.

1. Select & open your database -> Enter your table name and column count.( Columns are the part of tables like id, name, father_name, address. age ).

2. Now enter column name, Type ( Data type), length Values and if you are creating id column name then you must have to define id increment A_I .

After done all the process it will show newly created table.

How to start dynamic web development using PHP on Windows platform

What is dynamic web content.

Dynamic web content is that type of page content such as text, categories, web page url( Universe resource locator ) that regenerates each and every time when users load the website page. Website with dynamic content resources that dose not support static elements like static text, categories, tags. There are always a MySQL database behind every dynamic website. MySQL database is used to store all text data, URL's in it. Storing data on MySQL database server are also called as information about website related content. Every dynamic website dose not work without a back hand database and server side scripting language that can retrieve information from MySQL database server. At the present time the most popular scripting language with flexibility is PHP .

About PHP ( Hyper Text pre-processor ).

Full form of PHP is Hyper text preprocessor server side scripting language. PHP is most popular online dynamic web development scripting language because its provide the facility to create dynamic web elements on website. Php supports MySQL and MySQLi also and with the combination of both you can serve dynamic web contents on internet. Php is alos used to store data into MySQL database, retrieve data from MySQL database, Modify database elements like deletion of database elements, update, edit, add new. Php was developed in 1995 and from that day it will powering up millions of website on internet.

How to start web development in PHP on windows platform.

This is a php local server installation manual with step by step configuration. Installing php local server development environment on windows computer allows you to create, debug, run php files on your local system without affecting your main sever side web application. In this guide you will learn about How to install & configure php development environment on windows xp, windows vista, windows 7, windows 8.1, windows 10.

Configure php web development environment using Xampp server.

Before start making web pages using php programming language we need to install some of its tools to convert our local system directly to server system because php is server side scripting language and can only run on server side so we need to make our system as local server. Xampp is one of the most popular open source php local server creation environment software. Xampp is completely free contains Apache, MySQL, Perl and PHP. You can download and install xampp from here.

Steps to install Xampp Apache local server on Windows pc.

1. Download xampp server.
2. Run downloaded software as Run as administrator privileges.
3. After that you will able to see Bitnami xampp setup wizard window.
   
4. On the next setup window you have to select the components that you want to install. I preferred you to install all components.
   
5. Select the xampp installation direction path.
   
6. After done installing xampp sever on your computer. Start xampp control panel and Start Apache & MySQL.
   
7. Create a .php extension file then put that file on directory path as C:\xampp\htdocs\YourPHPProjectName\test.php .
8. Open any already installed web browser to test run php file then again type localhost/YourPHPprojectName/test.php to run your test.php file.

Here you go now your computer is ready to develop php websites, for any question or query please comment below.