SQL Statement

Most of the work of database is done by SQL. As an example below SQL statement fan-out all record from Student table.
SELECT *FROM student

SQL statement is not case sensitive. We can use this statement like ?select *from student?. It will show same result.

There are two types of SQL statement like DDL and DDM.

DDL- Data Definition Language:

These part contain create, alter, delete database etc statement. To define index(keys) for creating relationship between tables. Important DDL Statements are given below?

CREATE DATABASE - for a new database
ALTER DATABASE - alter a database
CREATE TABLE - creates a new table
ALTER TABLE -edit a table
DROP TABLE - remove a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
DML-Data Manipulation Language:
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database

All Tutorial => 123

Write Comment