Download Constructor java programming and more Schemes and Mind Maps Java Programming in PDF only on Docsity!
Experiment Title:DML COMMANDS
AIM: To demonstrate the DML Commands
Problem statement:Create a table Students which is having
columns ID,Name,City,Phone_no and Marks.
1.CREATE
Query:
Create table Student(ID int,Name varchar(50),City varchar(50),Phone_No int,Marks int);
Output:
Student
ID Name City Phone_No Marks
empty
2.INSERT
Query:
Insert Into Student(ID,Name,City,Phone_No,Marks)values (' 229 ','Pooja','Mumbai',' 7770473645 ',' 89 '), ('222','Roshni','Pune',' 7384362523 ','5 6 '), ('232','Sohan','Bengaluru',' 9990798232 ','6 8 '), ('242','Anmol','Delhi',' 8327487283 ','7 9 '), ('252','Taniya','Hyderabad',' 9990798293 ','4 6 '), ('262','Jay','Ahmedabad',' 7746328744 ','2 6 '), ('272','Anjali','Chennai',' 8820948290 ','9 2 '), ('282','Surveen','Kolkata',' 9328479834 ',' 29 ');
Output:
Student
ID Name City Phone_No Marks
229 Pooja Mumbai 7770473645 89
222 Roshni Pune 7384362523 56
232 Sohan Bengaluru 9990798232 68
242 Anmol Delhi 8327487283 79
252 Taniya Hyderabad 9990798293 46
262 Jay Ahmedabad 7746328744 26
272 Anjali Chennai 8820948290 92
282 Surveen Kolkata 9328479834 29
3.SELECT
Query:
Select * from student where Marks>80;
Output:
ID Name City Phone_No Marks
229 Pooja Mumbai 7770473645 89
Query:
Delete from Student where Marks<30;
Output:
Student
ID Name City Phone_No Marks
229 Pooja Mumbai 7770473645 89
222 Roshni Pune 7384362523 57
232 Sohan Bengaluru 9990798232 68
242 Anmol Delhi 8327487283 79
252 Taniya Hyderabad 9990798293 46
272 Anjali Chennai 8820948290 92
