Scribd
Upload
10 views6 pages

Mysql

The document outlines SQL commands for creating a database named 'vidhi' and a table 'student' with various fields including Rollno, name, DOB, City, English, and IP. It includes examples of inserting data into the student table using different methods. Additionally, it shows commands for selecting specific fields from the student table.

Uploaded by

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

Mysql

The document outlines SQL commands for creating a database named 'vidhi' and a table 'student' with various fields including Rollno, name, DOB, City, English, and IP. It includes examples of inserting data into the student table using different methods. Additionally, it shows commands for selecting specific fields from the student table.

Uploaded by

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

1.

Create databse vidhi ;

2.

show databases;

3.

Use vidhi ;

create table student

-> ( Rollno integer primary key,

-> name char(30) NOT NULL,

-> DOB date,

-> City varchar(30),

-> English integer Default 0,

-> IP float (5,2),

-> check ( english <=100),

-> check (IP <=100)

-> );

4.

desc student; / describe student;

5.

6.

insert into student values( 1101, 'Abhishek ', '1997-11-23','jaipur', 91 , 89.95 );


insert into student values( 1102, 'gopal', '1998-12-24','jaipur', 90 , 89.0 );

OTHER WAY TO INPUT VALUES

insert into student ( IP, english , name, RollNo, DOB, city ) values (
95.2, 90,' kapil',1103, '1999-07-09', 'Kota');

insert into student(rollno,name,dob,english,ip) values


(1104,'neeraj','2008-02-28',80,70.2);

insert into student values (1105,' NULL', ' 2008-01-05',amritsar, 79, 75.9);

insert into student values (1106,'sumit','2006-08,25','phalodi',68,70.30);

insert into student values(1107, ' krishna', '2005-09-06', 'jodhpur', 89.3, 92);

insert into student values (1108,' kavita','2009-10,09','jodhpur',52,82.8);

7.

8.

Select name from student;

9.

select rollno from student;

10.

11.

12.

13.

14.
15.

16.

17.

18.

19.

20.

2!.

22.

23.

24.

25.

26.

27.
28.

29.

30.

31.

32.

33.

34.

35.

insert into quaterlyexam;

36.
37.

38.

You might also like