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 tutorial pdf (18)
• phpmyadmin sql loop (17)
• phpmyadmin query tutorial (10)
• phpmyadmin interview questions (8)
• how to run a query in phpmyadmin (4)
• phpmyadmininterview questiond (4)
• phpmyadmin tutorial for beginners pdf (4)
• phpmyadmin loop mysql (3)
• how to remove leavepage error in yii (3)
• PHPmyadmin SQL pdf tutorial (3)
• query in phpmyadmin (3)
• loop phpmyadmin sql (2)
• interview question on phpmyadmin (2)
• interview questions on phpmyadmin for fresher (2)
• phpmyadmin sql for loop (2)
• phpMyAdmin to run the sql queries script (2)
• query script phpmyadmin (2)
• run while sql loop in phpmyadmin (2)
• phpmyadmin query loops (2)
• phpmyadmin query sql multiple (2)
• how can fill the textboxes in php mysq (2)
• phpmyadmin how to loop in sql script (2)
• xampp how to run a query (2)
• phpmyadmin loop sql (2)
• phpmyadmin run script (2)
• use pdf in php to display sql query (2)
• phpmyadmin queries tutorial (1)
• phpmyadmin php search script tutorial (1)
• phpmyadmin stop query (1)
• phpmyadmin to run sql script (1)
• phpmyadmin search multiple (1)
• phpmyadmin tut pdf (1)
• phpmyadmin mysql query step by step (1)
• phpmyadmin sql schleife (1)
• phpmyadmin sql query find script tag (1)
• phpmyadmin sql query create table (1)
• phpmyadmin run sql script (1)
• phpmyadmin search box (1)
• phpmyadmin run loop (1)
• phpmyadmin search query (1)

You will also be interested in ,

• Remote Mysql Connection From CPANEL And Connect To MYSQL Database From Your Local Webserver or Other External Web Server
• Simple auto suggest script using ajax php css and tags from wordpress
• Image gallery using php and mysql blob storage and displaying the image from mysql blob
• Connect to mysql using perl in xampp
• Tag cloud using php, mysql and ajax with filter
• Php mysql example image gallery blob storage
• Simple Visitor Counter Using php
• Total Number Of Rows In MYSQL
• Find the sum of multiple fields inside a table in mysql
• Website slow due to remote mysql server using php solution