Unable to Insert Data after Creating a MYISAM table

[varnendra maruthalingam]

Hi,

I am on Windows Vista and MYSQL Community Server downloaded and installed in Feb 2014.

I was able to create a table with the following quey;

CREATE TABLE sales_rep1 (
id INT AUTO_INCREMENT PRIMARY KEY,
employee_number INT(11),
surname VARCHAR(40),
first_name VARCHAR(30),
commission TINYINT(4),
date_joined DATE,
birthday DATE
) ENGINE=MyISAM;

Actually I had to change TYPE=MyISAM into ENGINE=MyISAM.

Then;

The following query returns error;

INSERT INTO sales_rep1 ('employee_number', 'surname',
'first_name', 'commission', 'date_joined', 'birthday')
VALUES (1,'Tshwete','Paul',15,'1999-01-03','1970-03-04');

Why?

Thank You,
M Varnendra