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:
Table: CITY
|
FIELD NAME
|
DATA TYPE | REMARKS |
| CITYCODE | CHAR (5) | Primary Key |
| CITYNAME | CHAR (30) | |
| SIZE | INTEGER | |
| AVGTEMP | INTEGER | |
| POLLUTIONRATE | INTEGER | |
| POPULATION | INTEGER |
Help her to complete the task by suggesting appropriate SQL commands.
Answer
Get live Maths 1-on-1 Classs - Class 6 to 12
