Monday, 7 September 2026

GRADE 12 : PRACTICAL 20 : PYTHON MYSQL CONNECTIVITY

 '''WAP using Python-MySQL connectivity to connect to the database DB20 and do the following :

> DISPLAY ALL RECORDS AND TOTAL NUMBER OF ROWS

> UPDATE THE TRAINS HAVING START AS 'PUNE JUNCTION' TO 'MUMBAI' INSTEAD

> DELETE DATA WHOSE END IS ACCEPTED.

> DISPLAY RECORDS OF A REQURED TNO.


P.S DB20 contains the following table

TABLE : TRAIN


 TNO  | TNAME                | START              | END 

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

11096 | AHIMSA EXPRESS       | PUNE JUNCTION      | AHMEDABAD JUNCTION

12015 | AJMER SHATABDI       | NEW DELHI          | AJMER JUNCTION

16513 | PUNE HBJ SPECIAL     | PUNE JUNCTION      | HABIBGANJ

13005 | AMRITSAR MAIL        | HOWRAH JUNCTION    | AMRITSAR JUNCTION  

12002 | BHOPAL SHATABDI      | NEW DELHI          | HABIBGANJ

12417 | PRAYAG RAJ EXPRESS   | ALLAHABAD JUNCTION | NEW DELHI

14673 | SHAHEED EXPRESS      | JAYNAGAR           | AMRITSAR JUNCTION

12314 | SEALDAH RAJDHANI     | NEW DELHI          | SEALDAH

12498 | SHANE PUNJAB         | AMRITSAR JUNCTION  | NEW DELHI 

12451 | SHRAM SHAKTI EXPRESS | KANPUR CENTRAL     | NEW DELHI

12030 | SWARNA SHATABDI      | AMRITSAR JUNCTION  | NEW DELHI

---------------------------------------------------------------------- '''