MySQL基础|mysql8基础 show tables 查看指定数据库中的所有表 MySQL基础|mysql

????OS : Ubuntu 18.04.1 LTS
??DBMS : mysql 8.0.12
???blog : blog.csdn.net/shiwanwu
?typesetting : Markdown

数据，数据，命根就在数据 ! 操作数据库时，一定要谨慎小心。师万物的代码看看就好，要有自己的判断。遇到抉择，要不耻上下问。

?
example

stu@Ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor.Commands end with ; or \g. Your MySQL connection id is 13 Server version: 8.0.12 MySQL Community Server - GPLCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.Type 'help; ' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases; +--------------------+ | Database| +--------------------+ | information_schema | | mysql| | performance_schema | | sys| +--------------------+ 4 rows in set (0.00 sec)mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed mysql> show tables; +---------------------------+ | Tables_in_mysql| +---------------------------+ | columns_priv| | component| | db| | default_roles| | engine_cost| | func| | general_log| | global_grants| | gtid_executed| | help_category| | help_keyword| | help_relation| | help_topic| | innodb_index_stats| | innodb_table_stats| | password_history| | plugin| | procs_priv| | proxies_priv| | role_edges| | server_cost| | servers| | slave_master_info| | slave_relay_log_info| | slave_worker_info| | slow_log| | tables_priv| | time_zone| | time_zone_leap_second| | time_zone_name| | time_zone_transition| | time_zone_transition_type | | user| +---------------------------+ 33 rows in set (0.01 sec)mysql> exit Bye stu@Ubuntu:~$

?
resource

[手册] dev.mysql.com/doc
[源码] downloads.mysql.com/archives/community
[Bug ] bugs.mysql.com
[ 测试数据 ] github.com/datacharmer/test_db
[规范 - 参考] yq.aliyun.com/articles/69327
[排名 - 参考] db-engines.com/en
[平台] www.csdn.net

?
【MySQL基础|mysql8基础 show tables 查看指定数据库中的所有表】MySQL是关系型数据库管理系统，目前是开源的(2019-02)。
明确权限，恰当地选择引擎与字符集等，规范命名。
MariaDB，Redis，MongoDB，PostgreSQL，Hive，HBase等，多作了解，拓宽心量。
Workbench，phpMyAdmin，Navicat等图形化管理工具，豫兮若冬涉川。