Scribd
Upload
20 views2 pages

SQL Commands for Student Database Management

The document outlines SQL commands for creating and managing a 'Student' table in a database, including the structure and data insertion. It details how to add columns and query the database to display student names based on certain criteria. Additionally, it mentions creating a 'Student Marks' table to track subjects and marks associated with each student.

Uploaded by

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

SQL Commands for Student Database Management

The document outlines SQL commands for creating and managing a 'Student' table in a database, including the structure and data insertion. It details how to add columns and query the database to display student names based on certain criteria. Additionally, it mentions creating a 'Student Marks' table to track subjects and marks associated with each student.

Uploaded by

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

0jasa Sinah

.. em V
Dale 9 lo12co
Ass ign ment Baed 0n 64L

4 wsiHe a Sql Comman d do Ciearle ho. folbolpa


ab le De laded to Shudent and obuo He the
datababe
Studlent able which ha ve follocoing, detoils
Student TO
Stu cent Name
Shudegt fa thenane
[Link] he 6|um maTna Stu det Chs8 Mae l
Hoble SHu dent
exist
CR EATE TABLE
Student
SHudetT0 I rmARy key,*
StudentName vOchao (35)
SHuden-+Eatherae Vaichax (ko)
JNSERT JTo SHucleH (SHudeH-IO S udert-Jarc,
Shudet o thezVomo)
VALVES
C123, 'Ritesh, 'ko07mt Sngh')
(133,'Komal , 'Amil Vagma')
(136, Ragm Mnvi + krno);
3 ' Konal., Rehid. vas
A"T 1ABLE Slucemt
DD Slucent tksikorne. Vochao ();
Add he (olu nne D-O S1uden4. im

ylng bleStutko
ud
ADD I6
ivwk a qurpy Ho disbloy the one uclets
wich av 0me name in SHudet chtobube .
wt
Hable
a
ques4 b disphy the Shsctme Student+
i. The
SE LEC Sucont. Jame, Counl( Student-NaTna)
FROMSludont
Gi RCUP By
SHuceNAME
HAVIWG
CoUT(Stuce-stJloma) >1,
.1he equided que? b
DESCRIQE ucent
ommand b Coeote ha able Studeyt
2- Wse Sal a
Mas Kb and opuda te ha database
Sudoat Mask hble having followi doHa ils
S+uceot Student Subsect1 SubTect2 Sub Tec13
Mas Madk Jo6 abaia MOBk
Add the olunm TaeÞeolentnge. in the Stulent
oble
CFAME 1ADLE S4ude»lnodkS(
uceot J D n4 ORIMAR Ke,
ule [Link](3
(3sutjcol ? h),sungt n

iníi07E
1 TABIE Sunl Ma7k

You might also like