Scribd
Upload
2 views1 page

RSSB SQL Commands Notes

Uploaded by

khushikansara2004
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

RSSB SQL Commands Notes

Uploaded by

khushikansara2004
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

RSSB Computer Instructor - SQL Commands Notes

Language Full Form Examples


DDL Data Definition Language CREATE, ALTER, DROP, TRUNCATE
DML Data Manipulation Language INSERT, UPDATE, DELETE
DQL Data Query Language SELECT
DCL Data Control Language GRANT, REVOKE
TCL Transaction Control Language COMMIT, ROLLBACK, SAVEPOINT

Basic Syntax
• CREATE TABLE Student (Roll_No INT, Name VARCHAR(20));
• ALTER TABLE Student ADD Age INT;
• DROP TABLE Student;
• TRUNCATE TABLE Student;
• INSERT INTO Student VALUES (101,'Khushi');
• UPDATE Student SET Name='Riya' WHERE Roll_No=101;
• DELETE FROM Student WHERE Roll_No=101;
• SELECT * FROM Student;
• GRANT SELECT ON Student TO User1;
• REVOKE SELECT ON Student FROM User1;
• COMMIT;
• ROLLBACK;
• SAVEPOINT A;

You might also like