GRADE 12 : PRACTICAL 21
'''WAP using Python-MySQL connectivity to connect to the Database DB21 that contains Table ACTIVITY as shown below :
PS. - THE BELOW SHOULD BE CREATED BY YOU IN MYSQL & CAN TABLE CAN BE STUCK ALONGSIDE OR BELOW , INSTEAD OF WRITING IT OUT
TABLE : ACTIVITY
ACODE| ANAME | STADIUM | NO | PRIZE | SCHEDULE_DATE
---------------------------------------------------------------------
1001 | RELAY 100M | STAR ANNEX | 16 | 10000 | 2004-01-23
1002 | HIGH JUMP | STAR ANNEX | 10 | 12000 | 2003-12-12
1003 | SHOTPUT | SUPER POWER | 12 | 8000 | 2004-02-14
1005 | LONG JUMP | STAR ANNEX | 12 | 9000 | 2004-01-01
1008 | DISCUS THROW | SUPER POWER | 10 | 15000 | 2004-03-19
---------------------------------------------------------------------
Your task is to :
1.DISPLAY THE ACTIVITIES THAT ARE SCHEDULED AT A STADIUM ACCEPTED BY THE USER. ALSO DISPLAY TOTAL NUMBER OF ACTIVITIES AT THIS STADIUM
2.INSERT A RECORD INTO THE TABLE
3.UPDATE NO. OF PARTICIPANTS AFTER ACCEPTING THE ACTIVITY NAME
4.DELETE DATA AFTER ACCEPTING ACTIVITY CODE FROM USER
- '''