Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Whats wrong with this MYSQL statement?
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
Heh.... "show" is the problem. Thanks guys! Can't have a field called show without backticks. SHOW is a command. Thanks for the help!
2 Answers
- 9 years agoFavorite 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
- AnalProgrammerLv 79 years ago
If store_id or user_id are numbers then the values for them should not be in quote.
Have fun.
