Syntax means following set of rules and patterns, even for SQL one has to follow the syntax. SQL is case in-sensitive, that is keyword SELECT and select is same for SQL. Every SQL command should end with a semi-colon (;).
If the syntax is not proper, then executing the command would result in syntax error.
SQL SELECT Command example:
SELECT col1, col2, col3,…..
Consider you have to select columns from a table, (this is most used command in SQL).
SELECT * FROM EMPLOYEE
The above command would result in the SQL implementation (here MYSQL) to wait for the ending command that is semicolon (;). Once you give the semicolon the command would be executed.
mysql> select * from employee
Empty set (0.00 sec)
In the above screenshot, you can see how MySQL executed the command only after ‘;’ was provided.