Команда SHOW предоставляет информацию по базам данных, таблицам, столбцам или о состоянии сервера.

Синтаксис MySQL команды SHOW следующий:

SHOW AUTHORS
SHOW {BINARY | MASTER} LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [like_or_where]
SHOW COLLATION [like_or_where]
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CONTRIBUTORS
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
SHOW CREATE FUNCTION func_name
SHOW CREATE PROCEDURE proc_name
SHOW CREATE TABLE tbl_name
SHOW CREATE TRIGGER trigger_name
SHOW CREATE VIEW view_name
SHOW DATABASES [like_or_where]
SHOW ENGINE engine_name {STATUS | MUTEX}
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [offset,] row_count]
SHOW EVENTS
SHOW FUNCTION CODE func_name
SHOW FUNCTION STATUS [like_or_where]
SHOW GRANTS FOR user
SHOW INDEX FROM tbl_name [FROM db_name]
SHOW MASTER STATUS
SHOW OPEN TABLES [FROM db_name] [like_or_where]
SHOW PLUGINS
SHOW PROCEDURE CODE proc_name
SHOW PROCEDURE STATUS [like_or_where]
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SHOW PROFILES
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
SHOW [GLOBAL | SESSION] STATUS [like_or_where]
SHOW TABLE STATUS [FROM db_name] [like_or_where]
SHOW [FULL] TABLES [FROM db_name] [like_or_where]
SHOW TRIGGERS [FROM db_name] [like_or_where]
SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
SHOW WARNINGS [LIMIT [offset,] row_count]

Например:

SHOW DATABASES выводит список баз данных

SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bitrix             |
| mysql              |
| sitemanager0       |
| test               |
+--------------------+
5 rows in set (0.00 sec)

SHOW TABLES выводит список таблиц базы данных

SHOW TABLES FROM bitrix;
+-------------------------------------+
| Tables_in_bitrix                    |
+-------------------------------------+
| b_adv_banner                        |
| b_adv_banner_2_country              |
| b_adv_banner_2_day                  |
| b_adv_banner_2_group                |
| b_adv_banner_2_page                 |
| b_adv_banner_2_site                 |
| b_adv_banner_2_stat_adv             |
| b_adv_banner_2_weekday              |
| b_adv_contract                      |
| b_adv_contract_2_page               |
| b_adv_contract_2_site               |
| b_adv_contract_2_type               |
| b_adv_contract_2_user               |
| b_adv_contract_2_weekday            |
| b_adv_type                          |
| b_agent                             |
| b_cache_tag                         |
| b_captcha                           |
| b_catalog_currency                  |
| b_catalog_currency_lang             |
| b_catalog_currency_rate             |
| b_catalog_discount                  |
| b_catalog_discount2cat              |
| b_catalog_discount2group            |
| b_catalog_discount2product          |
| b_catalog_discount2section          |
| b_catalog_discount_coupon           |
| b_catalog_export                    |
| b_catalog_extra                     |
| b_catalog_group                     |
| b_catalog_group2group               |
| b_catalog_group_lang                |
| b_catalog_iblock                    |
| b_catalog_load                      |
| b_catalog_price                     |
| b_catalog_product                   |
| b_catalog_product2group             |
| b_catalog_vat                       |
| b_event                             |
| b_event_log                         |
| b_event_message                     |
| b_event_message_site                |
| b_event_type                        |
| b_favorite                          |
| b_file                              |
| b_file_search                       |
| b_forum                             |
| b_forum2site                        |
| b_forum_dictionary                  |
| b_forum_email                       |
| b_forum_file                        |
| b_forum_filter                      |
| b_forum_group                       |
| b_forum_group_lang                  |
| b_forum_letter                      |
| b_forum_message                     |
| b_forum_perms                       |
| b_forum_pm_folder                   |
| b_forum_points                      |
| b_forum_points2post                 |
| b_forum_points_lang                 |
| b_forum_private_message             |
| b_forum_rank                        |
| b_forum_rank_lang                   |
| b_forum_smile                       |
| b_forum_smile_lang                  |
| b_forum_stat                        |
| b_forum_subscribe                   |
| b_forum_topic                       |
| b_forum_user                        |
| b_forum_user_forum                  |
| b_forum_user_points                 |
| b_forum_user_topic                  |
| b_group                             |
| b_group_collection_task             |
| b_group_subordinate                 |
| b_group_task                        |
| b_iblock                            |
| b_iblock_cache                      |
| b_iblock_element                    |
| b_iblock_element_lock               |
| b_iblock_element_property           |
| b_iblock_fields                     |
| b_iblock_group                      |
| b_iblock_messages                   |
| b_iblock_property                   |
| b_iblock_property_enum              |
| b_iblock_rss                        |
| b_iblock_section                    |
| b_iblock_section_element            |
| b_iblock_sequence                   |
| b_iblock_site                       |
| b_iblock_type                       |
| b_iblock_type_lang                  |
| b_lang                              |
| b_lang_domain                       |
| b_language                          |
| b_list_rubric                       |
| b_medialib_collection               |
| b_medialib_collection_item          |
| b_medialib_item                     |
| b_medialib_type                     |
| b_module                            |
| b_module_group                      |
| b_module_to_module                  |
| b_operation                         |
| b_option                            |
| b_perf_component                    |
| b_perf_error                        |
| b_perf_hit                          |
| b_perf_sql                          |
| b_perf_test                         |
| b_posting                           |
| b_posting_email                     |
| b_posting_file                      |
| b_posting_group                     |
| b_posting_rubric                    |
| b_sale_affiliate                    |
| b_sale_affiliate_plan               |
| b_sale_affiliate_plan_section       |
| b_sale_affiliate_tier               |
| b_sale_affiliate_transact           |
| b_sale_auxiliary                    |
| b_sale_basket                       |
| b_sale_basket_props                 |
| b_sale_delivery                     |
| b_sale_delivery2location            |
| b_sale_delivery_handler             |
| b_sale_discount                     |
| b_sale_export                       |
| b_sale_fuser                        |
| b_sale_lang                         |
| b_sale_location                     |
| b_sale_location2location_group      |
| b_sale_location_city                |
| b_sale_location_city_lang           |
| b_sale_location_country             |
| b_sale_location_country_lang        |
| b_sale_location_group               |
| b_sale_location_group_lang          |
| b_sale_location_zip                 |
| b_sale_order                        |
| b_sale_order_flags2group            |
| b_sale_order_props                  |
| b_sale_order_props_group            |
| b_sale_order_props_value            |
| b_sale_order_props_variant          |
| b_sale_order_tax                    |
| b_sale_pay_system                   |
| b_sale_pay_system_action            |
| b_sale_person_type                  |
| b_sale_product2product              |
| b_sale_recurring                    |
| b_sale_site2group                   |
| b_sale_status                       |
| b_sale_status2group                 |
| b_sale_status_lang                  |
| b_sale_tax                          |
| b_sale_tax2location                 |
| b_sale_tax_exempt2group             |
| b_sale_tax_rate                     |
| b_sale_user_account                 |
| b_sale_user_cards                   |
| b_sale_user_props                   |
| b_sale_user_props_value             |
| b_sale_user_transact                |
| b_search_content                    |
| b_search_content_freq               |
| b_search_content_group              |
| b_search_content_site               |
| b_search_content_stem               |
| b_search_custom_rank                |
| b_search_phrase                     |
| b_search_suggest                    |
| b_search_tags                       |
| b_sec_filter_mask                   |
| b_sec_iprule                        |
| b_sec_iprule_excl_ip                |
| b_sec_iprule_excl_mask              |
| b_sec_iprule_incl_ip                |
| b_sec_iprule_incl_mask              |
| b_sec_redirect_url                  |
| b_sec_session                       |
| b_sec_user                          |
| b_sec_virus                         |
| b_sec_white_list                    |
| b_seo_keywords                      |
| b_site_template                     |
| b_subscription                      |
| b_subscription_rubric               |
| b_task                              |
| b_task_operation                    |
| b_user                              |
| b_user_field                        |
| b_user_field_enum                   |
| b_user_field_lang                   |
| b_user_group                        |
| b_user_option                       |
| b_user_stored_auth                  |
| b_utm_iblock_4_section              |
| b_uts_iblock_4_section              |
| b_vote                              |
| b_vote_answer                       |
| b_vote_channel                      |
| b_vote_channel_2_group              |
| b_vote_channel_2_site               |
| b_vote_event                        |
| b_vote_event_answer                 |
| b_vote_event_question               |
| b_vote_question                     |
| b_vote_user                         |
| b_xml_tree                          |
| chatban                             |
| chatconfig                          |
| chatgroup                           |
| chatgroupoperator                   |
| chatmessage                         |
| chatoperator                        |
| chatresponses                       |
| chatrevision                        |
| chatthread                          |
| jos_banner                          |
| jos_bannerclient                    |
| jos_bannerfinish                    |
| jos_categories                      |
| jos_components                      |
| jos_contact_details                 |
| jos_content                         |
| jos_content_frontpage               |
| jos_content_rating                  |
| jos_core_acl_aro                    |
| jos_core_acl_aro_groups             |
| jos_core_acl_aro_sections           |
| jos_core_acl_groups_aro_map         |
| jos_core_log_items                  |
| jos_core_log_searches               |
| jos_groups                          |
| jos_ijoomla_news_categories_manager |
| jos_ijoomla_news_items_displayed    |
| jos_ijoomla_news_items_manager      |
| jos_ijoomla_news_layout             |
| jos_ijoomla_news_layout_settings    |
| jos_ijoomla_news_section_manager    |
| jos_ijoomla_news_separator_settings |
| jos_ijoomla_news_settings           |
| jos_ijoomla_news_zone_settings      |
| jos_jce_langs                       |
| jos_jce_plugins                     |
| jos_jp_def                          |
| jos_jp_packvars                     |
| jos_mambots                         |
| jos_menu                            |
| jos_messages                        |
| jos_messages_cfg                    |
| jos_modules                         |
| jos_modules_menu                    |
| jos_newsfeeds                       |
| jos_opensef_config                  |
| jos_opensef_sef                     |
| jos_opensef_sef_component           |
| jos_opensef_sef_site                |
| jos_poll_data                       |
| jos_poll_date                       |
| jos_poll_menu                       |
| jos_polls                           |
| jos_quickicon                       |
| jos_sections                        |
| jos_sef_sm_menu                     |
| jos_sef_sm_menus                    |
| jos_sef_sm_settings                 |
| jos_session                         |
| jos_stats_agents                    |
| jos_template_positions              |
| jos_templates_menu                  |
| jos_users                           |
| jos_usertypes                       |
| jos_vm_affiliate                    |
| jos_vm_affiliate_sale               |
| jos_vm_auth_user_vendor             |
| jos_vm_category                     |
| jos_vm_category_xref                |
| jos_vm_country                      |
| jos_vm_coupons                      |
| jos_vm_creditcard                   |
| jos_vm_csv                          |
| jos_vm_currency                     |
| jos_vm_function                     |
| jos_vm_manufacturer                 |
| jos_vm_manufacturer_category        |
| jos_vm_module                       |
| jos_vm_order_history                |
| jos_vm_order_item                   |
| jos_vm_order_payment                |
| jos_vm_order_status                 |
| jos_vm_order_user_info              |
| jos_vm_orders                       |
| jos_vm_payment_method               |
| jos_vm_product                      |
| jos_vm_product_attribute            |
| jos_vm_product_attribute_sku        |
| jos_vm_product_category_xref        |
| jos_vm_product_discount             |
| jos_vm_product_download             |
| jos_vm_product_files                |
| jos_vm_product_mf_xref              |
| jos_vm_product_price                |
| jos_vm_product_product_type_xref    |
| jos_vm_product_relations            |
| jos_vm_product_reviews              |
| jos_vm_product_type                 |
| jos_vm_product_type_1               |
| jos_vm_product_type_2               |
| jos_vm_product_type_parameter       |
| jos_vm_product_votes                |
| jos_vm_rp_assign_zone               |
| jos_vm_rp_state                     |
| jos_vm_rp_zone_rate                 |
| jos_vm_shipping_carrier             |
| jos_vm_shipping_rate                |
| jos_vm_shopper_group                |
| jos_vm_shopper_vendor_xref          |
| jos_vm_state                        |
| jos_vm_tax_rate                     |
| jos_vm_user_info                    |
| jos_vm_vendor                       |
| jos_vm_vendor_category              |
| jos_vm_visit                        |
| jos_vm_waiting_list                 |
| jos_vm_zone_shipping                |
| jos_weblinks                        |
+-------------------------------------+
330 rows in set (0.01 sec)