Adding data to a table

[luds]

I'm trying to add some sample data to a mysql table, but keep getting this error...

ERROR 1054: unknown column 'corbett' in 'field list'

The command that generates this is
INSERT INTO nmc_site_members (lastname, firstname) VALUES (corbett, harry);

Ideas anyone?

thanks
luds

 

[rzs0502]

You are missing the quotation marks on your values.

INSERT INTO nmc_site_members (lastname, firstname) VALUES ('corbett', 'harry');