you are viewing a single comment's thread
view the rest of the comments
[–] 4 points 2 years ago (2 children)

Other reply s accurate but it's always a good practice to include the semicolon else you can get

"Bobby tables'ed" look that xkcd comic up

  • source
  • parent
  • hideshow 4 child comments
  • [–] 8 points 2 years ago (1 child)

    I'm not sure how including a final semicolon can protect against an injection attack. In fact, the "Bobby Tables" attack specifically adds in a semicolon, to be able to start a new command. If inputs are sanitized, or much better, passed as parameters rather than string concatenated, you should be fine - nothing can be injected, regardless of the semicolon. If you concatenate untrusted strings straight into your query, an injection can be crafted to take advantage, with or without a semicolon.

  • source
  • parent
  • hideshow 2 child comments