What am I missing?

[tappiocca]

What am I missing to make this work? When I enter this:

INSERT INTO Comics (ComicNumber, ComicName, ComicTitle, ComicDate, AuthorId)
VAULES ('875', 'Detective Comics', 'Lost Boys', '2011-05-01', 1) 

I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VAULES ('875', 'Detective Comics', 'Lost Boys', '2011-05-01', 1)' at line 2
INSERT INTO Comics( ComicNumber, ComicName, ComicTitle, ComicDate, AuthorId )
VAULES('875', 'Detective Comics', 'Lost Boys', '2011-05-01', 1)

Thx in advance!

[ScallioXTX]

Read very carefully. You have:

VAULES

as opposed to

VALUES

[tappiocca]

Its the little things in life.. haha

[StarLion]

Rule of thumb:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'some text here' at line #

The red word is usually the problem, or you are missing/adding a comma/quote character in front of it.

[prensil]

Not exactly the red text shows the problem but MySQL interpreter could not parse the query further due to some previous error or error at that point.


Regards,
Hemant

[StarLion]

I'm aware of what it means. Most often however, the problem is related to that word, or the space directly before it. Which is what I said.