MySQL insert statement Syntax?

Question

I am posting a load of information to this file, and then trying to upload the information into the 'Cars' Table. I know the table works as I have tried single values and it worked.

I added all the values and now it throws 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 '`,`CurrColour`,`NoOfDoors`,`SeatingCap`,`Length`,`Width`,`Height`,`CombEngCap`,`' at line 2"

 ... "INSERT into `Cars`
            (`date`,`DVLAMake`,`DVLAModel`,`BodyStyle`,`EngineSize`,`Year`,`Transmission`,FuelType`,`CurrColour`,`NoOfDoors`,`SeatingCap`,`Length`,`Width`,`Height`,`CombEngCap`,`DriveType`,`MaxTorque`,`MaxPower`,`FuelConsumpURB`,`FuelConsumpCOMB`,`MaxSpeed`,`Acceleration`,`WeightKG`,`NCAPRating`,`SecRemCentLock`,`SecCentLock`,`SecAlarm`,`SecImmob`,`AudioEquip`,`ExtPowerAssSteer`,`ExtAssBreak`,`ExtElecWindows`,`ExtAirBags`,`ExtMirrors`,`ElecHeatedMir`,`IncWarranty`,`IncSerBook`,`IncMOT`,`IncPXConsid`,`CarImage`)
            VALUES
( ... ) ";

Any ideas?

Mr Mombassa, where is line 2? and please spent some effort to make your question more readable — ajreal
– ajreal, Commented Mar 19, 2012 at 13:47
MySQL error messages are usually pretty informative. Look at the context where it says there is an error: ',CurrColour,' The comma character you've got there looks different to the previous ones. Are you using a non-ASCII comma to separate some of the fields? — liquorvicar
– liquorvicar, Commented Mar 19, 2012 at 13:51
@liquorvicar: No, that's the website interpreting the backticks as code snippets. As @dleiftah mentioned already, he is missing a backtick before FuelType. — Travesty3
– Travesty3, Commented Mar 19, 2012 at 13:53

keithhatfield · Accepted Answer · 2012-03-19 13:50:20Z

2

You are missing a backtick before FuelType ... The error message clearly shows you where your error is ...

answered Mar 19, 2012 at 13:50

keithhatfield

3,2831 gold badge20 silver badges25 bronze badges

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

2 Comments

JEV Over a year ago

I corrected that, and it now jumps to the end : :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 'ScreenShot003.png')' at line 4 Screenshot is the value being passed through: VALUES (...'$PXConsidered','$image')";

keithhatfield Over a year ago

You may want to echo the query before executing it to see if anything looks amiss. Without seeing the query, it's hard to say what is causing the error ... It's likely a problem with one of the values that you are attempting to insert (not escaping a single quote or something to that effect) ...

Matt Gibson · Accepted Answer · 2012-03-19 13:48:56Z

0

You have a backtick:

IncPXConsid,CarImage`) VALUES

Is this deliberate? It could cause that error because you don't have one at the start of the brackets.

answered Mar 19, 2012 at 13:48

Matt Gibson

15k8 gold badges51 silver badges80 bronze badges

Collectives™ on Stack Overflow

MySQL insert statement Syntax?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related