BASIC ABOUT MYSQL SYNTAX

As every language have its own syntax how it can be written .Syntax is nothing but a set of rules that define how MYSQL understand. let us assume some body wrote first sentence left next sentence top and so on. Since he is not following the correct syntax so it is doubtful that anyone would read and understand it.My SQL is not different to from other language that follow a specific syntax.

MYSQL is easy to read ,write and understand .It make sence as long as user have English language understanding.

It is a good habit to use Capital letter for Reserve word while writing MYSQL query.It helps to separate the reserve words and also make the code more obvious at one look.

See the example below :

SELECT * FROM employee;

select * from employee;

Both the line display the same result but only first separate reserve words at look .So i will suggest to use first rest goes to you . You can follow anyone of the form while website development .

Leave a Reply to This Post

Your email address will not be published. Required fields are marked *

*

You may also like

Latest From 360 KLP Blog

Posted In: Tour and Travel

No matter, where you go, but reaching your destination on time is important. If not you reach your destination on time, you will have to face the issues according to the purpose you go for that destination. For example, if you are going to ai...

Posted In: Clothing

It is true that, most of us do not find time to wash our clothes as we are so busy in office and home. As far the cafes, hotels, salons and other offices are concerned, they need to definitely hire the laundry service to wash the clothes, as ...