Create Table SQL
CREATE TABLE tblPollutionCountry(
pmkPollutionCountry int NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldCountry VARCHAR(50) DEFAULT NULL,
fldAmount VARCHAR(50) DEFAULT NULL,
fldAmountOcean VARCHAR(50) DEFAULT NULL,
fldPopulation VARCHAR(50) DEFAULT NULL
)
Insert records into the table labs
INSERT INTO tblPollutionCountry
(pmkPollutionCountry, fldCountry,
fldAmount, fldAmountOcean, fldPopulation)
VALUES
(1, 'China', '8.80m', '3.53m', '1.338b'),
(2, 'Indonesia', '3.20m', '1.29m', '244m'),
(3, 'Philippines', '1.90m', '0.75m', '94.64m');