Contact US


Get Your Project Done by our experts
info@fundaofwebit.com

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.