Select Specific Rows From MySQL Tutorial Example

How To Select Specific Rows From MySQL Tutorial Example

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

-- How To Select Specific Rows From MySQL Tutorial Example

SELECT TestName, TestAge FROM  test WHERE TestID=10;

-- that's it!! TestName, TestAge columns of id=10 of mysql database table "test" has been selected
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

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

 

Related Tutorial Examples

  1. MySQL IFNULL() Function NULL Value Example
  2. MySQL IF() Nested Function Example
  3. MySQL IF() Function NULL Value Example
  4. MySQL IF() Function Datetime Value Example
  5. MySQL IF() Function String Value Example
  6. SELECT distinct... SQL Command MySQL Example
  7. MSSQL PRINT Like Function in MySQL Example
  8. 20 steps to make CakePHP Blog Project

No comments:

Post a Comment

leave your comments here..