Hack Forums
Information schema help - Printable Version

+- Hack Forums (https://hackforums.net)
+-- Forum: Hacks, Exploits, and Various Discussions (https://hackforums.net/forumdisplay.php?fid=45)
+--- Forum: Grayhat • Purple Team • Hybrid Security (https://hackforums.net/forumdisplay.php?fid=449)
+---- Forum: Website Hacking (https://hackforums.net/forumdisplay.php?fid=43)
+----- Forum: SQL Injection Attacks (https://hackforums.net/forumdisplay.php?fid=103)
+----- Thread: Information schema help (/showthread.php?tid=5765789)



Information schema help - Wolf72x - Dec 10, 2017

I am trying some Union tutorial i found here and got into little  problem.
I got table names (around 20 tables) but i can't get column names.

When I use :
Code
information_schema.columns where table_schema=database()

I get list of some columns on page.
But when I use where table_name=
and put table name i get nothing.
I tried it for all table names and every single one gives 0 results. :/
Some help?


RE: Information schema help - •^v^–[ bLacKn3x ]–^v^• - Dec 10, 2017

you have ro hex your table name with 0x prefix

table_name=0x6164


RE: Information schema help - Wolf72x - Dec 10, 2017

(Dec 10, 2017 05:43 AM)•^v^–[ bLacKn3x ]–^v^• Wrote:  you have ro hex your table name with 0x prefix

table_name=0x6164

Thanks for reply.
However I did hex it and also tried char with ascii but still gives me 0 results for every table :/


RE: Information schema help - pankajborah - Dec 11, 2017

where table_name=0xtablename


RE: Information schema help - Khagans - Feb 6, 2018

Sometime i also got little prob in information_schema