mysql lesson 3

mysql> UPDATE EMP SET SAL =850 WHERE SAL =800;

Query OK, 1 row affected (0.10 sec)

Rows matched: 1  Changed: 1  Warnings: 0SELECT * FROM EMP WHERE JOB='CLERK' AND COMM<=100 ;

mysql> ALTER TABLE EMP MODIFY JOB CHAR(30);

Query OK, 1 row affected (0.27 sec)

Records: 1  Duplicates: 0  Warnings: 0

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
8369	SMITH	CLERK	8902	1990-12-18	800	100	20
8999	HARPREET	CLERK	8878	1992-03-20	300	100	20

SELECT * FROM EMP WHERE(JOB = 'SALESMAN' AND SAL>= 300) OR (JOB = 'MANAGER' AND SAL>= 200);

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
8499	ANYA	SALESMAN	8698	1991-02-20	1600	300	30
8521	SETH	SALESMAN	8698	1991-02-22	1250	500	30
8566	MAHADEVAN	MANAGER	8839	1991-04-02	2985	200	20
8698	BINA	MANAGER	8839	1991-05-01	2850	400	30
8839	AMIR	MANAGER	8840	1991-11-18	3000	200	10
8993	TAJINDER	SALESMAN	8888	1992-03-11	3300	210	10