OK so now we know our target database is called AWS 10.
Let's try and discover the tables that exist in the database.
So this is our select statement.
It's the unions select one.
And we have these things.
So I'm going to leave this or change these to no because I don't I only want to select one thing now
and I'm going to say this to normal as well.
And any number two we're going to select table name
from now we're going to select this from a database called Information schema.
Now I said this in the first video of rescue all that information schema is a default database created
by my url and it contains information about all other databases.
So what we're doing now we're selecting the table name from information
schema dot.
And after the dot you put the table
so basically we're selecting a table called tables from a database called Information schema.
And the column that we're selecting is called table name so we're selecting table name from the database
that's called Information schema from the table tables.
Let's execute this and see if we can get all the tables that exist in our Spain database
so we can see we got two hundred and thirty seven records.
And you can see all the tables that we have.
So these are all the tables that we have access to.
So again I said we are logged in as root.
Therefore we can actually see tables from other Web applications such as the tiki weeki.
But in real life scenarios you'll only see tables related to your current database which is Madame de
so I'm going to do is I'm going to use a where clause and I'm gonna say where the table
schema is equal to I was 10 so I was 10 was what we got when we executed when we selected the database
so we got our spend which is our current database that's Matilda days working on.
So we were using the same statement we're selecting the table name from information schema tables where
the tables schema is ours 10 so I'm going to copy that and execute it here.
And as you can see now we have so many so much less tables and we only have the ones that we're interested
in and so we have the accounts the blogs capture data credit card hit log and the painter's tools.
Now if you remember in the first or the second video in the scale injection videos we I showed you what's
the content of the US table was and it was these tables of the US database.