Secure web hosting - Introducing MySQL SQL 51 Using SHOW MySQL includes
Introducing MySQL SQL 51 Using SHOW MySQL includes a command called SHOW, which allows a developer or administrator to see details about databases, tables, and the database system itself. In this section, we look at the various SHOW commands and explain what information they provide. Note that in some of the commands an optional LIKE can be used to filter the information provided by the command. The % wildcard is used just like as you do in the SELECT command use of LIKE. We cover the most popular SHOW commands here and save some of them for Chapter 13, Database Administration. SHOW DATABASES The SHOW DATABASES command shows all of the databases available on the current database server. You use the LIKE command to limit the output. For example: mysql> show databases; +———-+ | Database | +———-+ | accounts | | ca | | mysql | | test | +———-+ 4 rows in set (0.03 sec) SHOW TABLES The SHOW TABLES command displays all of the tables within a particular database. The full format of the command is: SHOW [OPEN] TABLES [FROM databaseName] [LIKE wildcardString] Notice that there are a number of optional components to the command. The [OPEN] option will show only those databases that are currently being accessed by a client. If SHOW TABLES is executed, it requires that a database currently be active by executing the USE
Note: If you are looking for inexpensive but high quality provider to host and run your serlvet application check Astra servlet hosting services