384 Part III . Administration mysqlshow Though complemented
384 Part III . Administration mysqlshow Though complemented by SHOWstatements in the CLI, the mysqlshow command can find the structure of databases, tables, and columns. The mysqlshow statement is unlike other commands in MySQL. You can t simply type the command to get a syntax printing. To see a syntax reference for the mysqlshowcommand, you should add the –help switch, as shown in Figure 14-10. Caution The -? switch is listed as a synonym for the –help switch, but it doesn t work. Figure 14-10: A syntax reference for the mysqlshow command is obtained by adding the –help switch. Using the mysqlshow command is quite similar to using other commands with MySQL: The -u switch defines the user, the -p switch can define the password, the -h switch defines the host, and so on. The output from the mysqlshow command is similar to the output from the equivalent CLI command (such as SHOW TABLES or SHOW COLUMNS). Examples of the output from the mysqlshow command appear in Figures 14-11 and 14-12.
If you are searching for cheap webhost for your web application, please visit MySQL5 Web Hosting services.