GRADE 12 - LAB 18
'''WAP using Python-MySQL connectivity to create the given
table and insert values. Create a menu driven program for :
MENU:
1.DISPLAY ONE RECORD
2.DISPLAY ALL RECORDS
3.DISPLAY DESIRED NUMBER OF RECORDS
4.DISPLAY TOTAL NUMBER OF ROWS
5.UPDATE SALARY
6.DELETE RECORD
7.SEARCH EMPLOYEES WITH SALARY ABOVE RS. 50000
TABLE : EMPLOYEE
+-------+---------------+---------+--------+------+------------+
| EOCDE | ENAME | DEPCODE | salary | AGE | JOINDATE |
+-------+---------------+---------+--------+------+------------+
| 15 | SAMEER SHARMA | 123 | 75000 | 39 | 2007-04-01 |
| 21 | RAGVINDER K | 101 | 86000 | 29 | 2005-11-11 |
| 34 | RAMA GUPTA | 119 | 52500 | 43 | 2010-02-03 |
| 46 | C R MENON | 103 | 67000 | 38 | 2004-07-12 |
| 77 | MOHAN KUMAR | 103 | 63000 | 55 | 2000-11-25 |
| 81 | RAJESH KUMAR | 119 | 74500 | 48 | 2008-12-11 |
| 89 | SANJEEV P | 101 | 92600 | 54 | 2009-01-12 |
| 93 | PRAGYA JAIN | 123 | 32000 | 29 | 2006-08-05 |
+-------+---------------+---------+--------+------+------------+
No comments:
Post a Comment