SQL SYNTAX
DATABASE TABLE
This is item table
|
Itemcode |
Itemname |
Price |
|
4001 |
pen |
300 |
|
4002 |
pencil |
45 |
|
4003 |
Notebook |
12 |
|
4004 |
Eraser |
3 |
Syntax in SQL
Select * from tablename;
Example: SELECT * FROM item ;
SQL KEYWORD - NOT CASE SENSITIVE
Select can be written in upper case or lower case.
SQL keyword is not case sensitive.
Example: select or SELECT
SEMI-COLON
It is mandatory to have semicolon(;) at the end of each query.