Walk Lightly on this PLANET and yet leave such a FOOTPRINT that cannot be erased for thousands of Years..!!!
Visit Codstech for Cyber Security related Posts !

Visitors

Tuesday, March 19, 2013

3 : SQL Statements

SQ can be divided into 2 parts.

1 : DML (Data Manipulation Language)

  • SELECT
  • UPDATE
  • DELETE
  • INSERT INTO

2 : DDL (Data Definition Language)

  • CREATE DATABASE
  • ALTER DATABASE
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • CREATE INDEX
  • DROP INDEX
Now we are going to learn a little bit about all the Queries used in SQL , with Example.