Running My SQL Query via PhpMyAdmin
In Inway Hosting chapter of PhpMyAdmin, you will learn about constructing and running My SQL query. There are two modes of running My SQL query, which further depends on MySQL syntax level of knowledge. We provide best web hosting india
Advance users can choose SQL tab, there you can insert the SQL query code, Click on Go Button to apply it.
Another option is to construct, MySQL query in Query tab.
Here you can define different search option, sort out results and query about multiple Tables.
Firstly, select the tables from the Table list, which has to use in the query.
Pick the fields mentioned in SELECT My SQL statement from the main menu, by clicking the check box visible there.
In the column of criteria Text, enter criteria in such way, that search will be completed.
With the help of Sort Drop- down menu, one can check whether result sorted in Ascending or descending order.
Extra search functions can be completed, by inserting in text Window located there.
In addition to this, one can use Ins and Del checkbox for adding or deleting Text rows .Same function can be done through Add/Del criteria Row in Drop – Down menu.
In the modify option, one can describe the relations between different Fields, to see whether they are connected through AND or OR logical operators.
Now, click on Update query button to process all modifications of database.
Click on “submit” button to run the query.
Here we have mentioned some e.gs of query.
SELECT `AT_admins`. * FROM AT_admins (where `AT_admins`. `Login` LIKE “a %”);
It displays all the records starting from AT_admin tables for which login details start with “a”.