QUERYING MYSQL

 (1)

mysql> create database st;

mysql> use st;

 (2)

mysql> create table dept(deptno int primary key,deptname varchar(30),schoolnamevarchar(30));

mysql> create table emp(empno int primary key,deptno int,name varchar(30),design varchar(30),salary int,specialization varchar(30)references emp(empno));

(3)

mysql> insert into dept values(12,'mba','management');

mysql> insert into dept values(13,'mba','financial');

mysql> insert into dept values(14,'mca','computer applications');

mysql> insert into dept values(15,'mba','management');

mysql> insert into dept values(16,'mba','human resources');

mysql> insert into emp values(101,10,'bala','lecturer',15000,'programming');

mysql> insert into emp values(102,11,'priyan','lecturer',6000,'programming');

mysql> insert into emp values(103,12,'suresh','media',16000,'photography');

mysql> insert into emp values(104,13,'vimal','lecturer',25000,'theorey');

mysql> insert into emp values(105,14,'ram','teacher',5000,'maths');

mysql> insert into emp values(106,15,'suri','manager',25000,'financial');

mysql> insert into emp values(107,16,'hari','teacher',4000,'physics');

mysql> insert into emp values(108,17,'vasanth','manager',6000,'financial');

mysql> insert into emp values(109,18,'karthi','manager',6000,'financial');

mysql> insert into emp values(110,19,'naveen','manager',90000,'tally');

(4)

mysql> describe emp;

mysql> describe dept;

 (5)

mysql> select * from dept order by deptname;

(6)

mysql> select *from emp order by name desc;

(7)

mysql> select count(*) as numberofrecords,deptname from dept group by deptno;

(8)

mysql> select empno,deptno,name,desig as post,salary,specialization from emp order by name desc;

(9)

mysql> select *from emp limit 5,3;

 (10)

mysql> select dept.deptno,dept.deptname,dept.schoolname,emp.empno,emp.deptno,emp.name,emp.desig,emp.salary,emp.specialization from dept,emp where emp.deptno=dept.deptno;