sql insert keeps getting error

Question

I am fairly new to sql and I've run into an error while trying to insert a row into a MySQL database. I am binding values before inserting to the database to prevent from sql injection.

My insert statement:

INSERT INTO member (FirstName, LastName, Date of Birth, Street Address, 
                   City, State, Zip, Email, Phone, Active)
VALUES (:FirstName, :LastName, :DateOfBirth, :streetAddress, :City, :State, 
                    :Zip, :Email, :Phone, :Active)

Is the primary key required in the insert statement? I do have it set to auto increment in the database.

The error I keep getting is:

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 '"'FirstName', 'LastName', 'Date of Birth', 'Street Address', 'City', 'State', 'Z' at line 1

I've tried working around the syntax of the statement itself and I'm fairly certain it is syntactically correct although my sql knowledge is very very limited. Thank you for your time.

Tama198

in oracle when there is space in column name, we should include such in Double Quotes. But i am not sure about my sql — Maddy
– Maddy, Commented May 4, 2012 at 5:02
I had no idea about spaces in column names thanks. unfortunately, I tried once with quotes around the name, and a second time by removing the spaces in the column names itself. Both were unsuccessful. — Tama198
– Tama198, Commented May 4, 2012 at 5:10

sarwar026 · Accepted Answer · 2012-05-04 04:57:32Z

2

Try with

INSERT INTO member (FirstName, LastName, `Date of Birth`, `Street Address`, 
                   City, State, Zip, Email, Phone, Active)
VALUES (:FirstName, :LastName, :DateOfBirth, :streetAddress, :City, :State, 
                    :Zip, :Email, :Phone, :Active)

Please check your table column name "Date of Birth" and "Street Address". Is column name allow space!! I am doubt of it.

answered May 4, 2012 at 4:57

sarwar026

3,8413 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tama198 Over a year ago

Thanks sarwar026, however I removed the spaces for the column names in the database and changed my insert statement with no change in the error. Are there settings in phpmyadmin that need changed in order to insert new rows?

sarwar026 Over a year ago

What is your primary key? is it an auto-incremented field?

Tama198 Over a year ago

My primary key was column ID. although I had to change it to auto-increment and it worked fine. I thought I had auto-increment set to ID and apparently it wasn't. Still trying to learn the database world. Thank you sarwar026 and madhu for your help. Very Grateful!

Collectives™ on Stack Overflow

sql insert keeps getting error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related