{keyword}' Union All Select Null,null,null,null,null,null,null,null-- Jynz Apr 2026
: Appends a new set of results to the original query's output.
The primary objective of using this payload is . For a UNION operation to work, the injected query must have the exact same number of columns as the original query.
: Attempts to select 8 columns of "null" data. : Appends a new set of results to
: This is a SQL comment, which tells the database to ignore the rest of the original, legitimate query that follows. The Goal of the Attack
The payload you provided, ' UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL-- , is a common pattern used in to determine the number of columns returned by an original database query. What this Payload Does : Attempts to select 8 columns of "null" data
If the column count is wrong (e.g., the original query has 7 or 9 columns), the database will return an error.
This specific string is designed to be appended to a vulnerable input field (the {KEYWORD} in your example) to probe the database structure: : Closes the original string literal in the SQL query. What this Payload Does If the column count is wrong (e
NULL is used because it is compatible with almost any data type (string, integer, date, etc.), ensuring the query won't fail due to data type mismatches.