MySQL管理——操作和查看数据库的命令
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQL管理——操作和查看数据库的命令,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含7555字,纯文字阅读大概需要11分钟。
内容图文
![MySQL管理——操作和查看数据库的命令](/upload/InfoBanner/zyjiaocheng/512/743f59bf3daa4715ae8d0d45e6ddc68c.jpg)
示例:
1 mysql> show databases; 2 +--------------------+ 3 | Database | 4 +--------------------+ 5 | information_schema | 6 | mysql | 7 | performance_schema | 8 +--------------------+ 9 3 rows in set (0.00 sec) 10 11 mysql>
指定要使用的数据库
语法:
1 show 数据库名;
示例:
1 mysql> use mysql; 2 Reading table information for completion of table and column names 3 You can turn off this feature to get a quicker startup with -A 4 5 Database changed 6 mysql>
查询指定数据库所有的表
语法:
1 show tables;
示例:
1 mysql> show tables; 2 +---------------------------+ 3 | Tables_in_mysql | 4 +---------------------------+ 5 | columns_priv | 6 | db | 7 | event | 8 | func | 9 | general_log | 10 | help_category | 11 | help_keyword | 12 | help_relation | 13 | help_topic | 14 | host | 15 | ndb_binlog_index | 16 | plugin | 17 | proc | 18 | procs_priv | 19 | proxies_priv | 20 | servers | 21 | slow_log | 22 | tables_priv | 23 | time_zone | 24 | time_zone_leap_second | 25 | time_zone_name | 26 | time_zone_transition | 27 | time_zone_transition_type | 28 | user | 29 +---------------------------+ 30 24 rows in set (0.00 sec) 31 32 mysql>
查询指定表的字段
语法:
1 show columns from 表名;
示例:
1 mysql> show columns from user; 2 +------------------------+-----------------------------------+------+-----+---------+-------+ 3 | Field | Type | Null | Key | Default | Extra | 4 +------------------------+-----------------------------------+------+-----+---------+-------+ 5 | Host | char(60) | NO | PRI | | | 6 | User | char(16) | NO | PRI | | | 7 | Password | char(41) | NO | | | | 8 | Select_priv | enum(‘N‘,‘Y‘) | NO | | N | | 9 | Insert_priv | enum(‘N‘,‘Y‘) | NO | | N | | 10 | Update_priv | enum(‘N‘,‘Y‘) | NO | | N | | 11 | Delete_priv | enum(‘N‘,‘Y‘) | NO | | N | | 12 | Create_priv | enum(‘N‘,‘Y‘) | NO | | N | | 13 | Drop_priv | enum(‘N‘,‘Y‘) | NO | | N | | 14 | Reload_priv | enum(‘N‘,‘Y‘) | NO | | N | | 15 | Shutdown_priv | enum(‘N‘,‘Y‘) | NO | | N | | 16 | Process_priv | enum(‘N‘,‘Y‘) | NO | | N | | 17 | File_priv | enum(‘N‘,‘Y‘) | NO | | N | | 18 | Grant_priv | enum(‘N‘,‘Y‘) | NO | | N | | 19 | References_priv | enum(‘N‘,‘Y‘) | NO | | N | | 20 | Index_priv | enum(‘N‘,‘Y‘) | NO | | N | | 21 | Alter_priv | enum(‘N‘,‘Y‘) | NO | | N | | 22 | Show_db_priv | enum(‘N‘,‘Y‘) | NO | | N | | 23 | Super_priv | enum(‘N‘,‘Y‘) | NO | | N | | 24 | Create_tmp_table_priv | enum(‘N‘,‘Y‘) | NO | | N | | 25 | Lock_tables_priv | enum(‘N‘,‘Y‘) | NO | | N | | 26 | Execute_priv | enum(‘N‘,‘Y‘) | NO | | N | | 27 | Repl_slave_priv | enum(‘N‘,‘Y‘) | NO | | N | | 28 | Repl_client_priv | enum(‘N‘,‘Y‘) | NO | | N | | 29 | Create_view_priv | enum(‘N‘,‘Y‘) | NO | | N | | 30 | Show_view_priv | enum(‘N‘,‘Y‘) | NO | | N | | 31 | Create_routine_priv | enum(‘N‘,‘Y‘) | NO | | N | | 32 | Alter_routine_priv | enum(‘N‘,‘Y‘) | NO | | N | | 33 | Create_user_priv | enum(‘N‘,‘Y‘) | NO | | N | | 34 | Event_priv | enum(‘N‘,‘Y‘) | NO | | N | | 35 | Trigger_priv | enum(‘N‘,‘Y‘) | NO | | N | | 36 | Create_tablespace_priv | enum(‘N‘,‘Y‘) | NO | | N | | 37 | ssl_type | enum(‘‘,‘ANY‘,‘X509‘,‘SPECIFIED‘) | NO | | | | 38 | ssl_cipher | blob | NO | | NULL | | 39 | x509_issuer | blob | NO | | NULL | | 40 | x509_subject | blob | NO | | NULL | | 41 | max_questions | int(11) unsigned | NO | | 0 | | 42 | max_updates | int(11) unsigned | NO | | 0 | | 43 | max_connections | int(11) unsigned | NO | | 0 | | 44 | max_user_connections | int(11) | NO | | 0 | | 45 | plugin | char(64) | NO | | | | 46 | authentication_string | text | NO | | NULL | | 47 +------------------------+-----------------------------------+------+-----+---------+-------+ 48 42 rows in set (0.00 sec) 49 50 mysql>
查询指定表的索引
语法:
1 show index from 表名;
示例:
1 mysql> show index from user; 2 +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 3 | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | 4 +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 5 | user | 0 | PRIMARY | 1 | Host | A | NULL | NULL | NULL | | BTREE | | | 6 | user | 0 | PRIMARY | 2 | User | A | 3 | NULL | NULL | | BTREE | | | 7 +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 8 2 rows in set (0.00 sec) 9 10 mysql>
MySQL管理——操作和查看数据库的命令
标签:comm unsigned code cipher iss quic procs reading 命令
本文系统来源:https://www.cnblogs.com/shamao/p/11371574.html
内容总结
以上是互联网集市为您收集整理的MySQL管理——操作和查看数据库的命令全部内容,希望文章能够帮你解决MySQL管理——操作和查看数据库的命令所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。