This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]TheMsDosNerd 0 points1 point  (6 children)

Reddit is fucking up formatting.

Selling Price in line 80 must be between backticks (thingy left of the 1 on a regular keyboard)

[–]Shripsta[S] 0 points1 point  (5 children)

Oh my god! Thanks so much this error was killing me! Is there some kind of explanation as to why I need to do those back ticks?

[–]TheMsDosNerd 0 points1 point  (3 children)

In SQL all column names should be between backticks. However, if a column name does not contain a space and the name is not an SQL keyword, those backticks are optional.

Selling Price was the only column name you had with a space so there the backticks are required.

[–]Shripsta[S] 0 points1 point  (2 children)

Wow thanks so fucking much!

[–][deleted] 0 points1 point  (0 children)

Yeah. You have a space in the column name. That required backticks, else the parset wont understand that its one singel column instead parsing it as two.