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

Honest question, which ones wouldn't it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?

  • source
  • parent
  • hideshow 5 child comments
  • [–] 4 points 2 years ago (3 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 3 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 1 child comment