{keyword} And (select 8148 From(select Count(*),concat(0x7162717671,(select (elt(8148=8148,1))),0x7171627171,floor(rand(0)*2))x From Information_schema.character_sets Group By X)a)-- Qkgc -
It looks like your query contains some SQL injection syntax ( SELECT COUNT , CONCAT , INFORMATION_SCHEMA ). If you're looking for an on how these types of database queries work—specifically regarding web security and SQL injection (SQLi) —I can certainly help with that. What is this code?
The attacker isn't trying to delete data yet; they are trying to "fingerprint" the database. It looks like your query contains some SQL
It uses functions like CONCAT and GROUP BY to intentionally trigger a duplicate-key error. The database's error message will then "leak" the information hidden inside the query (in this case, the results of the SELECT 1 or version info) back to the attacker's screen. The attacker isn't trying to delete data yet;
If you are a developer, you can stop these attacks using three main methods: If you are a developer, you can stop
If a website's search bar or URL parameter isn't properly "sanitized," an attacker can use this method to: (e.g., MySQL, PostgreSQL). Extract table names and column structures.
like usernames, hashed passwords, or emails. How to Prevent It
These are hexadecimal representations of characters (like 'qbqvq') used as delimiters so the attacker can easily spot their "stolen" data in the middle of a messy error message. Why is it dangerous?