Check sibling questions

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?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.