lord elgin watch dating - Mysql invalidating query

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.