How to run a SQL query in phpMyAdmin

Objective: In this tutorial, you will learn how to run a query using phpMyAdmin for use in our other tutorials.

Step 1: Create a database.Note:-If using cPanel, click MySQL® Databases, and create a new database, then click phpMyAdmin!

Step 2: Select the database you want to use on the left. If you have 1 database, there will be one, click it. If there is more than one, there will be a drop down box, use that to select the database you made in step 1.

Step 3: Click on the SQL tab on the top of the screen, it should be almost dead center.

Step 3: You will be presented with a text box, enter into that text box

Code:

CREATE TABLE `table` (

`row1` VARCHAR( 255 ) NOT NULL ,

`row2` VARCHAR( 255 ) NOT NULL

) ENGINE = MYISAM ;

Then click “Go”

You should now be presented with a message similar to this

Quote:

Of course the time for it may be quicker or slower, depending on server factors and such.

Step 4: Optional By now clicking Structure you will see a new line:

You can click and do stuff to it using phpMyAdmin’s built in functions. You can insert data, remove data, edit data and get a feel for phpMyAdmin.

Step 5:

Click SQL Again, and enter this:

Code:

DROP TABLE `table`;

Guessing from the code, it will drop our new table called `table` which should be visible in the left sidebar.

Incoming search terms:

• phpmyadmin sql loop (16)
• phpmyadmin tutorial pdf (15)
• phpmyadmin query tutorial (10)
• phpmyadmin interview questions (6)
• phpmyadmininterview questiond (4)
• how to run a query in phpmyadmin (4)
• phpmyadmin loop mysql (3)
• query in phpmyadmin (3)
• PHPmyadmin SQL pdf tutorial (3)
• phpmyadmin query sql multiple (2)
• interview questions on phpmyadmin for fresher (2)
• phpmyadmin sql for loop (2)
• phpmyadmin run script (2)
• interview question on phpmyadmin (2)
• query script phpmyadmin (2)
• run while sql loop in phpmyadmin (2)
• phpmyadmin query loops (2)
• phpmyadmin loop sql (2)
• xampp how to run a query (2)
• phpmyadmin how to loop in sql script (2)
• use pdf in php to display sql query (2)
• phpMyAdmin to run the sql queries script (2)
• phpmyadmin queries tutorial (1)
• phpmyadmin sql schleife (1)
• phpmyadmin php search script tutorial (1)
• phpmyadmin mysql for loop (1)
• phpmyadmin mysql query step by step (1)
• phpmyadmin to run sql script (1)
• phpmyadmin sql query find script tag (1)
• phpmyadmin run loop (1)
• phpmyadmin sql loop select (1)
• phpmyadmin run sql multiple script (1)
• phpmyadmin run sql script (1)
• phpmyadmin search multiple (1)
• phpmyadmin query tutorial criteria (1)
• phpmyadmin search query (1)
• phpmyadmin search sql table (1)
• phpmyadmin search mutli (1)
• phpmyadmin sql insert loop (1)
• phpmyadmin query scripting (1)

You will also be interested in ,

• Find the sum of multiple fields inside a table in mysql
• Export MySQL to CSV (Excel) using php
• Mysql backup via cron using php and email the file
• Simple Visitor Counter Using php
• Set xampp:- Apache Mysql Filezilla Mercury Tomcat as a windows service and get xampp to start automatically on boot up
• Total Number Of Rows In MYSQL
• Simple Mysql table with AUTO_INCREMENT attribute
• Export MySql database table to pdf using php
• Count distinct records or values and display it using mysql and php
• Get IP address using gethostbyname() function