Sql Syntax

Sql Syntax know as all SQL Statement which governed by ANSI and ISO. like Create Database, ALTER Database, Select, Update, Delete, Insert, Create Table, ALTER Table etc.

SQL Statements

Basically SQL statement very easy to understand and learn because plain English but with specific syntax. Every SQL statement will be end with Semicolon (;).

Basic Statement of select

SELECT Column1, Column2, Columnn3 FROM tableName;
SELECT employee_name, email, mobile FROM tblEmployee;

Upon the given SQL query SELECT is statement of SQL, employee_name, email, mobile is Column name, FROM is Keyword of SQL and tblEmployee is Table Name of Database.

SQL Case Sensitivity 

SQL Keywords are not Case Sensitive or other hand SQL statement are Insensitive that means select or SELECT are same in SQL.

SELECT employee_name, email, mobile FROM tblEmployee;
select employee_name, email, mobile from tblEmployee;

Note: By the way the database and table names may case-sensitive depending on the your operating system. In general, Unix or Linux operating system are case-sensitive, whereas Windows operating system are not case-sensitive

SQL Comments

Basicaly SQL comments have two types, first is single line (--) and second is multi line comments start with  (/*) and end with (*/).

Single Line SQL Comments

--SELECT employee_name, email, mobile FROM tblEmployee;
SELECT employee_name, email FROM tblEmployee;

Multi Line SQL Commnets

/*SELECT employee_name, 
email, mobile FROM tblEmployee where Id >10;*/

SELECT employee_name, 
email, mobile FROM tblEmployee where Id >10;