Select Data From MySQL Table Tutorial Example

How To Select Data From MySQL Table Tutorial Example

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

-- How To Select Data From MySQL Table Tutorial Example

SELECT * FROM  test;

-- that's it!! all rows and all columns 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 Data From MySQL Table Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL interval() Function Example
2. MySQL coalesce() Function Example
3. MySQL isnull() Function Example
4. MySQL least() Function Datetime Value Example
5. MySQL least() Function String Value Example
6. SELECT all rows of a Table using SQL Command MySQL Example
7. How To Find MySQL SERVER VERSION Information
8. 20 steps to make CakePHP Blog Project