SELECT .. FROM:

SELECT is one of most commonly used DML(Data Manipulation Language) commands. It is used to retrieve data from the database. The general form for a SELECT statement, retrieving all of the rows in the table is:

SELECT ColumnName, ColumnName, ...
FROM TableName;

Lets us look at the following table (tbl_employee) including five fields: Social_Security , Last_Name, First_Name, Address and Zip_Code:

If you want to retrive all the information in the table,  use the following statement:

SELECT * FROM tbl_employee

The result from the command is

If you want to limit the number of fields from the table use the following command

SELECT First_Name, Last_Name, Zip_Code 
FROM tbl_employee

The following is the results of your query of the database:

To explain what you just did, you asked for the all of data in the table tbl_employee, and specifically, you asked for the fields called First Name, Last Name, Zip Coe. Note that column names and table names do not have spaces.

Back to the homepage