Ayush M Delhi Adarsh M Delhi Abinandh M Chennai INSERT INTO Student VALUES ( , 'Beena', 'F', , 'Cochin'); COMMIT; Admno Name Gender Age Place Revathi F Chennai Devika F Bangalore Ayush M Delhi Adarsh M Delhi Abinandh M Chennai Beena F Cochin UPDATE Student SET Name = ‘Mini’ WHERE Admno= ; SAVEPOINT A; Admno Name Gender Age Place Mini F Chennai Devika F Bangalore Ayush M Delhi Adarsh M Delhi Abinandh M Chennai Beena F Cochin 12th Computer Chapter - - Structured Query Language INSERT INTO Student VALUES( , 'Jisha', 'F', , 'Delhi'); SAVEPOINT B; Admno Name Gender Age Place Mini F Chennai Devika F Bangalore Ayush M Delhi Adarsh M Delhi vAbinandh M Chennai Beena F Cochin Jisha F Delhi ROLLBACK TO A; Admno Name Gender Age Place Mini F Chennai Devika F Bangalore Ayush M Delhi Adarsh M Delhi Abinandh M Chennai Beena F Cochin • SQL is a language that helps to create and operate relational databases. • MySQL is a database management system. • The various components of SQL are Data Definition Language ( DDL ), Data Manipulation Language ( DML ), Data Query Language ( DQL ), Transactional Control Language ( TCL ), Data Control Language ( DCL ). • The DDL provides statements for creation and deletion of tables.
• The DML provides statements to insert, update and delete data of a table. • The DCL provides authorization commands to access data. • The TCL commands are used to manage transactions in a database. • The DQL commands help to generate queries in a database.
• The CREATE TABLE command creates a new table. Points to remember: 12th Computer Chapter - - Hands on Experience . Create a query of the student