Questions about this topic? Sign up to ask in the talk tab.

Difference between revisions of "SQL injection/Target Environments/Compatibility/functions and variables"

From NetSec
Jump to: navigation, search
(Created page with "Similarities between the different engines '''MS SQL''', '''MySQL''', and '''PostgreSQL''' share the following: * ascii() * substring() * count() * lower() * upper() * '''BETWEE...")
 
 
Line 1: Line 1:
 +
<noinclude>:<font size="-2">[[SQL injection]] > [[SQL injection/Target Environments|Target Environments]] > [[SQL injection/Target Environments/Compatibility|Compatibility]] > functions and variables</font></noinclude>
 +
 
Similarities between the different engines
 
Similarities between the different engines
  

Latest revision as of 03:22, 19 July 2012

SQL injection > Target Environments > Compatibility > functions and variables

Similarities between the different engines

MS SQL, MySQL, and PostgreSQL share the following:

  • ascii()
  • substring()
  • count()
  • lower()
  • upper()
  • BETWEEN ... AND ... conditional operator

MySQL and Postgres share the following:

  • current_database()
  • version()
  • current_user
  • LIMIT ... OFFSET ... clause syntax

MySQL and MSSQL share the following:

  • database()
  • @@version
  • RLIKE clause for regular expressions