Easy SQL Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't get past this - I am inserting a record into a db and I keep getting
the same SQL SYNTAX ERROR MESSAGE. Below is the statement i am using with
test data. All fields in the database are text fields with no restrictions.

Syntax error in INSERT INTO statement.
INSERT INTO
Student(FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,EMAIL,ADDRESS,ADDRESS1,CITY,STATE,ZIP,PHONE_HOME,PHONE_CELL,PHONE_WORK,FAX,PASSWORD,COUNTRY)
VALUES ('2', '3', '4', '5', '6', '7', '8', '9', '1', '2', '3', '4', '5', '6',
'7')
 
I suspect that PASSWORD is a reseved word.

Short term fix, try using square brackets, e.g. [PASSWORD].

Ideally, columns should not be named using words reserved by the database
engine.
 
Back
Top