Loading

SQL syntax

  • The syntax of the structured query language is a unique set of rules and guidelines, which are not case-sensitive.
  • Its Syntax is defined and maintained by ISO and ANSI standards.

Some important points about SQL syntax are:

  • You can write the Keywords of SQL in both uppercase and lowercase, but writing the SQL keyword in uppercase improves the readability of the SQL query.
  • SQL syntax or statements are dependent on text lines We can place a single SQL statement on one or multiple text lines.
  • You can perform most of the action in a database with SQL statements.

SQL statements:

  • Most of the actions you need to perform on a database are done with SQL statements.
  • SQL statements tell the database what operation you want to perform on the structured data and what information you would like to access from the database.

Example:

SELECT “column_name” FROM “table_name”;
  • Each SQL statement begins with any of the SQL keywords and ends with the semicolon(;).
  • The semicolon is used for separating the multiple SQL statements which are going to execute in the same call.