MySQL ERROR 'Unknown Column in field list'

[s3nzo]

Hey guys please help me once again i have a problem with MySQL i'm trying to insert data but it's returning this error message

#1054 - Unknown column 's3nzo' in 'field list'

Here's MySQL query

INSERT INTO users (id, nick, firstname, lastname, age, country, city)
VALUES (NULL, s3nzo, Alexa, goodle, 12, USA, NY) 

I already tried this
Solution it didn't work

[Redisblood]

Did u tried single quots for char values? Thats required.

[s3nzo]

Thank you guys, single quotes worked

[Engelsmann]

Also, be aware which quotes you use: Backquotes ` are used for table and field names ONLY.
Single quotes, as brokenheart uses in his example, are meant for strings, and thus Brokenheart uses quotes right in his example.

Here is how I came through with no errors:

INSERT INTO `supplier`
SET `address`='Kong Georgs Vej 31, 2000 Frederiksberg', `company`='Pedersen og Christoffersen El ApS', `contact_fname`='Søren', `contact_lname`='Christoffersen', `contact_phone`='38776655', `contact_phone_is_mobile`='0', `fax`='38776650', `mail`='', `main_phone`='38776655', `preferred`='fax', `trade`='f', `user`='USER', `user_group`='TEST'