×
Everything you do now is for your future. Think About that.
--Your friends at LectureNotes
Close

Lab Manuals for Database Management System - DBMS By Mohit Kaushik

  • Database Management System - DBMS
  • Practical
  • A.I.J.H.M COLLEGE - Jat
  • 907 Views
  • 22 Offline Downloads
  • Uploaded
Mohit Kaushik
Mohit Kaushik
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

PRACTICAL FILE ON DBMS ALL INDIA JAT HEROE’S MEMORIAL COLLEGE, ROHTAK TABLE OF CONTENTS 1

Text from page-2

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

Text from page-3

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

Text from page-4

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