×
Study for the day when you don't have to worry about price tags.
--Your friends at LectureNotes
Close

Database Management System

by Mohit KaushikMohit Kaushik
Type: PracticalInstitute: A.I.J.H.M COLLEGE Offline Downloads: 20Views: 531Uploaded: 2 months ago

Share it with your friends

Suggested Materials

Leave your Comments

Contributors

Mohit Kaushik
Mohit Kaushik
PRACTICAL FILE ON DBMS ALL INDIA JAT HEROE’S MEMORIAL COLLEGE, ROHTAK TABLE OF CONTENTS 1
Sr.No Name Of The Program 1 To Create a Table 2 To Insert a Record In Database 3 To Select Distinct Address From Table 4 To Find Query From a Record Using AND ,OR & NOT 5 To List The Record Of Sorted Table(Asc,Desc) 6 To Delete a Record From a Table 7 To Alter a Record Of Table 8 To Show Use Of Some Operators(Arithmetic ,Relational ,Range Searching, Pattern Matching) 9 To Rename a Table 10 To Show Current Date, Current Time 2 Teacher’s Sign
Mysql> Create Database Superstars; ------------------------------------------------------------------------------------------------------------------------------Mysql> Show Databases; Database Information_Schema College Company Superstars Db Employ Hum Msc Student Test ------------------------------------------------------------------------------------------------------------------------------Mysql> Drop Database Msc; ------------------------------------------------------------------------------------------------------------------------------Mysql> Show databases; Database Information Schema College Company Superstars Db Employ Hum Student Test ------------------------------------------------------------------------------------------------------------------------------Mysql> Use Superstars; 3
Database Changed ------------------------------------------------------------------------------------------------------------------------------Mysql> Create Table moon(id int,namevarchar(30), address varchar(40),marks int); ------------------------------------------------------------------------------------------------------------------------------Mysql> Insert Into moon Values(1,'Mohit','Rohtak',90); Mysql> Insert Into moon Values(2,'Deepak','Gohana',50); Mysql> Insert Into moonValues(3,'Ronit','Karnal',60); Mysql> Insert Into moon Values(4,'Priya','Rohtak',70); Mysql> Insert Into moonValues(5,'Sachin','Chandigarh',80); Mysql> Select * From moon; ID 1 2 3 4 5 NAME Mohit Deepak Ronit Priya Sachin ADDRESS Rohtak Gohana Karnal Rohtak Chandigarh MARKS 90 50 60 70 80 ------------------------------------------------------------------------------------------------------------------------------Mysql> Select Distinct Address From moon; ADDRESS Rohtak Gohana Karnal Chandigarh 4

Lecture Notes