My SQL | Short Notes | Class 12 | CS | Computer Science

-


               MY SQL

____________________

 

#DATABASE

To create database

Create database xyz:

 

#USE COMMAND

To use database

Use xyz:


#COMMAND TO DISPLAY EXISTING DATA

• Show databases:

• Show Tables:

 

# USE OF TABLE COMMAND

To create table

Create table abc(slno int, stdnm varchar(30), fathernm varchar(30), class char(3), sec char(1), marks int):

 

#USE OF DESC

To describe the table

desc abc:

 

#USE OF INSERT

To insert value inside table

insert into abc values(1, "aditya","alok","XI", "A",330):

 

insert into abc values(2,"abhay","aman","XII","B",410):

 

#USE OF   *  as ALL

To show the full table

Select* from abc:

 

#USE OF SELECT 

To show any selected of coulmn

Select stdnm, marks from abc:

 

#USE OF UPDATE

To update any data in table

update abc set marks=390 where slno=2:

 

#USE OF PRIMARY KEY

To set a primary key

create table abc(slno int primary key, stdnm varchar (30), fathernm varchar(30), class char(3),sec char(3), marks int):

 

#USE OF UNIQUE

Create table pqr(roll_no int primary key,reg_no. char(8) unique.....){can be used more than one}

 

#USE OF OPERATER(<,>,=,+,-,*,/)

Use of operaters

Select * from abc where marks>350:

 

#USE OF ALTER

To Change structure of table

Alter table abc add (admission_no char(12)):

 

#USE OF LIKE

To get a row of specific type

Select * from abc where stdnm like '_%':

 

#USE OF ORDER BY

To arrange data in order

select * from abc order by marks: {desc=descending/ by default ascending}

 

#SUM FUNCTION

To sum up integer

Select sum(marks) from abc:

 

#AVERAGE FUNCTION

To find average of integer

Select avg(marks) from abc:

 

#MIN FUNCTION

To find minimum

Select min(marks) from abc:

 

#MAX FUNCTION

To find maximum

Select max(marks) from abc:

 

#USE OF COUNT

To count the number of data

Select count(*) from abc:

 

#USE OF DROP

To delete any coulmn

alter table abc drop fathernm: (column name)

 

#USE OF ALTER

To make changes in coulmn

alter table abc modify class=std char(3):

 

#USE OF FOREIGN KEY

To connect two tables

1) create table abc (roll_no int primary key, stdnm varchar(30), fathernm varchar(30), std char(3), sec char(2), marks char(3)):

 

2) create table pqr (roll_no int, Adhar_no char(16), Address, foreign key(roll_no) references abc(roll_no)):

 

·    select roll_no, stdnm, Adhar_no, std, marks, address from abc, pqr where abc.roll_no=pqr.roll_no:

 

#DISTINCT COMMAND

To show common data once

Select distinct (marks) from abc:

 

--------------------------------------------------

MY SQL TERMS:-

Tuple ---- row record

Attribute ---- column record

Degree ---- no. of column

Cardinality ---- no. of rows

Relation ---- table

--------------------------------------------------

 

 

 

_______________________________

DDL: Data Definition Language

             eg:- create, alter, drop

            

DML: Data Manipulation Language

             eg:- insert, update, delete, etc.

 

Difference between primary key and unique key

Primary 

•can be used once.

• helps in use of primary key. 

 

 Unique

• can be used more than once

•it allows to enter null value



Click here for pdf Notes

 

Comments

Post a Comment

Popular posts from this blog

Class 12th Physics and Chemistry Handwritten Notes... ⚗️⚖️⚛️

-
Hello Everyone !! kaise ho aaap sab..?? I hope sab achhe honge...... Handwritten Notes       Hello Science      _____________________________    NOTES:- CLASS 12TH {CHEMISTRY} Chapter 1 The Solid State Chapter 2 Solution Chapter 3 Electrochemistry Chapter 4 Chemical Kinetics Chapter 5 Surface Chemistry Chapter 7 The P-block Element        • Group 15: Nitrogen Family (Pnictogen)       •Group 16: Oxygen Family (Chalocogens)        •Group 17: Halogens        •Group 18: Noble Gas   Chapter 8 D and F block elements Chapter 9 Coordination Compounds Chapter 10 Haloalkanes and Haloarenes Chapter 11 Alcohol Phenol And Ether Chapter 12 Aldehyde Ketones & Carboxylic Acid Chapter 13 Amines Chapter 14 Biomolecules CLASS 12TH {PHYSICS} CHAPTER 1 TO 7 FORMULAS PDF Chapter 1 Electric Charge And Field Chapter 2 Electrostatic Potential and Capacitance Chapter 3 Current Electricity...
Read more

Electric Charge And Field | Chap 1 | Class 12th | Physics | Handwritten Notes

-
Image
 All of us have the experience of seeing a spark or hearing a crackle when we take off our synthetic clothes or sweater, particularly in dry weather.This is almost inevitable with ladies garments like a polyester saree. Have you ever tried to find any explanation for this phenomenon? Another common example of electric discharge is the lightning that we see in the sky during thunderstorms. We also experience a sensation of an electricshock either while opening the door of a car or holding the iron bar of abus after sliding from our seat. The reason for these experiences is discharge of electric charges through our body, which were accumulated due to rubbing of insulating surfaces. You might have also heard that this due to generation of static electricity. This is precisely the topic we are going to discuss in this and the next chapter. Static means anything that does not move or change with time. Electrostatics deals with the study of forces, fields and potentials arising from stat...
Read more

The Solid State | Chap 1 | Class 12th Chemistry | Handwritten Notes

-
Image
From our earlier studies, we know that liquids and gases are called  fluids  because of their ability to flow. The fluidity in both of these states is due to the fact that the molecules are free to move about. On the contrary, the constituent particles in solids have fixed positions and can only oscillate about their mean positions. This explains the rigidity in solids. These properties depend upon the nature of constituent particles and the binding forces operating between them. The correlation between structure and properties helps in the discovery of new solid materials with desired properties. For example, carbon nanotubes are new materials that have potential to provide material that are tougher than steel, lighter than aluminium and have more conductive property than copper. Such materials may play an expanding role in future development of science and society. Some other materials which are expected to play an important role in future are high temperature superconductor...
Read more

Haloalkanes & Haloarenes | Chap 10 | Class 12th | Organic Chemistry | Handwritten Notes

-
Image
 The replacement of hydrogen atom(s) in an aliphatic or aromatic hydrocarbon by halogen atom(s) results in the formation of alkyl halide (haloalkane) and arylhalide (haloarene), respectively. Haloalkanes contain halogen atom(s) attached to the sp3 hybridised carbon atom of an alkyl group whereas haloarenes contain halogen atom(s) attached to sp2 hybridised carbon atom(s) of an aryl group. 
Read more

Engineering semester 2: Digital System Design With Hardware Descriptive Language(Verilog)

-
"Digital System Design with Hardware Descriptive Language" is a fascinating subject that delves into the intricate world of designing and implementing digital systems using specialized languages. This field combines theoretical knowledge with practical skills to create efficient and reliable digital systems. Understanding hardware descriptive languages such as Verilog and VHDL is crucial for engineers and designers working in the digital domain. In this course, students will explore the fundamentals of digital logic design, sequential and combinational circuits, finite state machines, and more. They will learn how to express their designs using hardware descriptive languages, enabling them to simulate and synthesize complex digital systems. The study materials provided in the course cover each chapter comprehensively, offering in-depth explanations, examples, and exercises to reinforce learning. To access detailed notes for every chapter and enhance your understanding of digi...
Read more