Whats wrong with this MYSQL statement?

Question

INSERT INTO store_profiles ( store_id, user_id, title, address_1, address_2, city, state, zip, phone, email, website, active, show ) VALUES ( '700580','564','Skyway Workout','123 North Johnson Drive','','Beverly Hills','CA','90210','(310) 555-1234','','','1','TRUE' )

The quote marks after the phone number are two single quotes in a row, not one double quote :)

I get the following error

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 'show ) VALUES ( '700580','564','Skyway Workout','123 North Johnson Drive','','Beverly Hil' at line 1

JB · Accepted Answer

It's a little hard to say for sure without knowing the structure of your database, so the only thing I could say is check your "store_profiles" schema and make sure the data you are entering is in the correct form.  Do your website/email fields allow for null values?  Check your keys

AnalProgrammer · Answer

If store_id or user_id are numbers then the values for them should not be in quote.

Have fun.

Whats wrong with this MYSQL statement?

Related Questions

Trending Questions