16 articles Database

Sql Statement

DML command SQL is equipped with data manipulation language. DML modifies the database instance by inserting, updating and deleting its data. DML is responsible for all data modification in databases. SQL contains the following set of command in DML section: SELECT/FROM/WHERE INSERT INTO/VALUES UPDATE/SET/WHERE DELETE FROM/WHERE 1) INSERT command Insert command is used to insert…

SQL Overview

SQL (pronounced “ess-que-el”) stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.It is designed over relational algebra and tuple relational calculus. SQL comes as a package with all major distributions of RDBMS.