Select Specific Columns From MySQL Tutorial Example

How To Select Specific Columns From MySQL Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to select or retrive specific columns data from a database table "test" in MySQL Database Server

-- How To Select Specific Columns From MySQL Tutorial Example

SELECT TestName, TestAge FROM  test;

-- that's it!! TestName, TestAge columns of all rows of mysql database table "test" have been selected

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Select Specific Columns From MySQL Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL IF() Function Number Value Example
2. MySQL IF() Function Boolean Value Example
3. MySQL strcmp() Function Number Value Example
4. MySQL strcmp() Function NULL Value Example
5. MySQL strcmp() Function Example :: on Equals,Large.. Values
6. SELECT specific row(s) of a Table using SQL Command MySQL Example
7. How to Find MySQL Stored Procedure or Function Information
8. 20 steps to make CakePHP Blog Project