Sql
Today we will be talking about the SQL command SELECT. You can try out the comand here : http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
We can use the SELECT statement to get data from an database, the select command wants to get some information.
It needs to know what data we want, and from where it needs to get it. The information we want will be typed directly afther the SELECT command, and to tell it where to get it from we will use the FROM statement. In sql the commands and statements are always typed in caps and the parameters in lower case.
An example :
We have a database made of a list of computers with there Brands,Types,Serial numbers,Operatingsystems. The table name = Computers and the columns are Brands, Types, Serial_numbers, Operating_systems.
If we want to see all the computers with all the information we whould use the following command :
SELECT * FROM computers;
In plain english it says :
Select all entrys from computers and show us all data.
As an example this whould print out :
Asus pro72 6876245 Windows 7
But it whould do so for every entry, this is something we don't want. In my next post il show you how to specifie our searches.
Seeya !
