Finding tables in a particular database Now its time to find out what tables exist in a particular database.
Lets say the database of interest over here is ‘krypton’ Command: and the output will look something like this: (there is to many to screen shot) Lets get the columns of a particular table now.
The output could be something like this: The output shows the existing databases on the remote system.
Note: on nearly all db’s there is an “information_schema” database and generally contains fuck-all.
Now that we have the list of tables with us, it would be a good idea to get the columns of some important table. The output will be something like this: Now comes the most interesting part, of extracting the data from the table.