What am I missing?

PHP
1

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!

2

Read very carefully. You have:

VAULES

as opposed to

VALUES

:wink:

3

Its the little things in life… haha

4

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.

5

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

6

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.