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 suggQL commands.
esting appropriate S
Answer
(
CITYCODE CHAR(5)PRIMARY KEY
,
CITYNAME CHAR(30),
SIZE INT,
AVGTEMP INT,
POPULATIONRATE INT,
POPULATION INT,
);
Are ads bothering you?