Re: MySQL Errors (Syntax, Undefined Table, etc.)

[J C]

Script:

USE CIA_DATA;

CREATE TABLE CIADataset (
'Water' decimal(3,1) NOT NULL,
'Sanitation' decimal(3,1) NOT NULL,
'GDP' int NOT NULL,
'Life' decimal(3,1) NOT NULL,
'Underweight' decimal(3,1) NOT NULL,
'Literacy' decimal(3,1) NOT NULL,
'Electricity' decimal(3,1) NOT NULL,
'Country' decimal(45) NOT NULL,
PRIMARY KEY ('Country')
) ENGINE=InnoDB;

DROP TABLE CIADataset;

SELECT * FROM CIADataset;

I still have the same errors.

Thanks