INSERT INTO Student (Name, Age) VALUES (“Vijay”, “25”) Used for removing one or more rows from a table. These commands are not auto-committed, which simply means that all changes made to the database using DML commands aren’t automatically saved. The DML or Data Manipulation Language commands help in modifying a relational database. DML Commands - Data Manipulation Language General Syntax: TRUNCATE TABLE table_name Ģ. Used for deleting all rows from a table and free the space containing the table. General Syntax: RENAME old_table_name TO new_table_nameĮxample: RENAME Student TO Student_Details Used for deleting an entire table from the database and all the data stored in it. General Syntax: CREATE TABLE table_name (column_name1 data_type(size), column_name2 data_type(size),…., column_nameN data_type(size)) Įxample: CREATE TABLE Employee(Name varchar2(20), D.O.B. Used for creating a new table in the database. Note: - It is not possible to do the following using the ALTER command: General Syntax: ALTER TABLE table_name DROP COLUMN column_name Įxample: ALTER TABLE Student DROP COLUMN Age The ALTER command can also be used for dropping a column from the table: General Syntax: ALTER TABLE table_name MODIFY (column_name new_data_type(new_size)) Įxample: ALTER TABLE Student MODIFY (Name varchar2(20)) There are a total of 5 types of SQL commands, as described below: So, learning SQL commands with examples is the first step towards learning SQL. Everything ranging from creating a table and adding data to modifying a table and setting user permissions is accomplished using Basic SQL commands. SQL commands are used for communicating with the database. Oracle Database, MySQL, Microsoft SQL Server, PostgreSQL, and MariaDB are some of the most popular relational database management systems. It is also used for stream processing in a relational data stream management system. Sequential Query Language or SQL is the most widely used programming language for managing data in a relational database management system. TCL Commands - Transaction Control Language

Basic sql tutorial pdf