Union select null, null, null, null, null, null, null from information_schema.tables. for a small database containing three tables. this instruction is used in sql injection I tried it and it worked but I didn't really know how it works can somebody help me...
sql - Union to handle NULL values - Stack Overflow ...
When you want to replace a possibly null column with something else, use IsNull. SELECT ISNULL(myColumn, 0 ) FROM myTable.
...NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULl, NULL-- Можно использовать CAST
A null pointer constant is defined as "An integer constant expression with the value 0, or such an expression cast to type void *". Counterintuitively, this definition does not require the expansion of NULL to be an expression of pointer type. A common implementation is
NULL представлен точно так же: поле с данными отсутствует, а в поле с длиной записывается 0xFF.
Select name from ships where class = name union select ship as name from classes,outcomes where classes.class = outcomes.ship. Задание: 37 (Serge I: 2003-02-17). Найдите классы, в которые входит только один корабль из базы данных (учесть также корабли в Outcomes).
SELECT CHAR(0x66) (S) SELECT 0x5045 (this is not an integer it will be a string from Hex) (M)
The null character (also null terminator or null byte) is a control character with the value zero. It is present in many character sets, including ISO/IEC 646 (or ASCII), the C0 control code, the Universal Coded Character Set (or Unicode), and EBCDIC.
-1 UNION SELECT group_concat(username, 0x3a, password) FROM admin.