Scribd
Upload
21 views2 pages

Code Final

This document provides examples of SQL commands to view, select, update, delete and manipulate data in database tables. It shows how to select records by field values, order results, count records, update and delete data, create and drop tables, and insert sample data.

Uploaded by

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

Code Final

This document provides examples of SQL commands to view, select, update, delete and manipulate data in database tables. It shows how to select records by field values, order results, count records, update and delete data, create and drop tables, and insert sample data.

Uploaded by

Gaurishankar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

TO VIEW THE STRUCTURE OF THE TABLE

mysql> DESC <TABLE NAME>;


TO DISPLAY THE CONTENTS IN THE TABLE
mysql> SELECT * FROM <TABLE NAME>;
TO VIEW THE TABLE IN ASCENDING ORDER MARKS
mysql> SELECT * FROM XIB2 ORDER BY MARKS;
TO VIEW THE NAME OF THE STUDENTS ASCENDING ORDER OF THEIR MARKS
mysql> SELECT NAME FROM <TABLE NAME> ORDER BY MARKS;
TO DISPLAY THE NAME OF THE TEACHER/STUDENT/ EMPLOYEE WHOSE NAME STARTS WITH M.
SELECT NAME FROM <TABLE NAME> WHERE NAME LIKE 'M%';

OR TO DISPLAY NAME AND DEPARTMENT FROM """


SELECT NAME,DEPARTMENT FROM <TABLE NAME> WHERE NAME LIKE 'M%';

DISPLAY NAME OF THE FEMALE TEACHERS IN HISTORY DEPARTMENT


SELECT NAME FROM <TABLE NAME> WHERE GENDER='F' AND DEPARTMENT='HISTORY';

COUNT THE NUMBER OF RECORD IN THE TABLE


SELECT COUNT(*) FROM <TABLE NAME>;

TO CHANGE THE NAME OF THE TEACHER AS MEENA WHOSE TR NO 225


UPDATE TEACHER SET NAME='MEENA' WHERE TRNO=225;

TO DISPLAY THE LOWEST SALARY IN THE TABLE


SELECT MIN(SALARY) AS "LOWEST SALARY" FROM <TABLE NAME>;

DISPLAY THE NAME AND SALARY AND DEPARTMENT OF THE TEACHER IN THE DESCENDING ORDER
OF THIER SALARY
SELECT NAME,SALARY,DEPARTMENT FROM <TABLE NAME> ORDER BY SALARY;

TO DELETE THE DETAILS OF MALE / FEMALE TEACHERS

IF MALE
DELETE FROM <TABLE NAME> WHERE GENDER='M';

IF FEMALE
DELETE FROM <TABLE NAME> WHERE GENDER-='F';

DELETE THE WHOLE TABLE


DROP TABLE <TABLE NAME>;

TO VIEW THE NAME OF THE EMPLOYEE WHO IS GETTING SALARY BETWEEEN 15K-20K
SELECT NAME FROM <TABLE NAME> WHERE SALARY>=15000 AND SALARY<=20000;

TO CREATE TABLE EMPLOYEE


CREATE TABLE EMPLOYEE(EMPNO INT(3) PRIMARRY KEY NOT NULL,NAME
VARCHAR(10),DESIGNATION VARCHAR(10),SALARY INT(6));

TO INSERT THE VALUES


INSERT INTO EMPLOYEE VALUES(201,"ANAGH","CLERK",15000);

INSERT INTO EMPLOYEE VALUES(203,"DEEPU","CLERK",17000);

INSERT INTO EMPLOYEE VALUES(101,"ARJUN","MANAGER",20000);

INSERT INTO EMPLOYEE VALUES(303,"CYRIAC","SALER",12000);

TO SEE THE NAME AND SALARRY OF "" WHOSE DESIGNATIO IS CLERK


SELECT NAME,SALARY FROM EMPLOYEE WHERE DESIGNATION='CLERK';

DETAILS OF EMPLOYEE WHOSE LETTER CONTAINS A

SELECT * FROM EMPLOYEE WHERE NAME LIKE '%A%';

TO VIEW AVERAGE SALARY


SELECT AVG(SALARY) AS AVERAGE;

TO DELETE THE WHOLE TABLE


DROP TABLE EMPLOYEE;

You might also like