Today I found and watched some of the tutorials about SQL
http://www.w3schools.com/sql/sql_intro.asp
Summary:
Basic:
1. Select
Syntax: SELECT (DISTINCT) column_name(s) FROM table_name (WHERE column_name operator value)
* represents all the data
2. Order
Syntax: SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
3.Insert
Syntax:INSERT INTO table_name (column1, column2, column3,…) VALUES (value1, value2, value3,…)
or INSERT INTO table_name VALUES (value1, value2, value3,…)
4. Update
Syntax: UPDATE table_name SET column1=value, column2=value2,… WHERE some_column=some_value
5. Delete
Syntax: DELETE FROM table_name WHERE some_column=some_value
Advance:
1. Top
Syntax: SELECT TOP number|percent column_name(s) FROM table_name
2.Like
Syntax: SELECT column_name(s) FROM table_name WHERE column_name (NOT) LIKE pattern
Wildcards:
% A substitute for zero or more characters
_ A substitute for exactly one character
[charlist] Any single character in charlist
[^charlist] or [!charlist] Any single character not in charlist
3. In: allows to specify multiple values in a WHERE clause
Syntax: SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,…)
http://www.w3schools.com/sql/sql_between.asp