• September 25, 2014
  • SQL
  • Comments Off on SQL Syntax

SQL Syntax

Syntax:

Syntax is a set of rules and guidelines which defines the structure of statements in a computer language.

SQL syntax:

SQL syntax is a set of rules and guidelines which defines the structure of SQL statements. SQL is case insensitive.

Commonly used SQL commands:

1. SELECT – It is used to extract data from a database.

2. UPDATE – It is used to update data in a database.

3. DELETE – It is used to delete data from a database.

4. INSERT INTO – It is used to insert new data into a database.

5. CREATE DATABASE – It is used to create a new database.

6. ALTER DATABASE – It is used to modify an existing database.

7. CREATE TABLE – It is used to create a new table.

8. ALTER TABLE – It is used to modify an existing table.

9. DROP TABLE – It is used to delete an existing table.

10. CREATE INDEX – It is used to create an index (search key).

11. DROP INDEX – It is used to delete an existing index.

 
Next Topic: SQL data type.
Previous Topic: Database overview.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.