CodesJava

Easy learning with example program codes

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.

 

Posted in SQL   


Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki