Charu has to create a database named MYEARTH in MYSQL. She now needs to create a table named CITY in the database to store the records of various cities across the globe. The table CITY has the following structure:
|CITYCODE||CHAR (5)||Primary Key|
Help her to complete the task by suggQL commands.
esting appropriate S
CITYCODE CHAR(5)PRIMARY KEY