//1.查询库mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test || ytl |+--------------------+5 rows in set (0.00 sec)//2.切换选择库mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql>//查看库里的表mysql> show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || event || func || general_log || help_category || help_keyword || help_relation || help_topic || innodb_index_stats || innodb_table_stats || ndb_binlog_index || plugin || proc || procs_priv || proxies_priv || 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 |+---------------------------+28 rows in set (0.00 sec)//查看表里的字段mysql> desc user;+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Field | Type | Null | Key | Default | Extra |+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Host | char(60) | NO | PRI | | || User | char(16) | NO | PRI | | || Password | char(41) | NO | | | || Select_priv | enum('N','Y') | NO | | N | || Insert_priv | enum('N','Y') | NO | | N | || Update_priv | enum('N','Y') | NO | | N | || Delete_priv | enum('N','Y') | NO | | N | || Create_priv | enum('N','Y') | NO | | N | || Drop_priv | enum('N','Y') | NO | | N | || Reload_priv | enum('N','Y') | NO | | N | || Shutdown_priv | enum('N','Y') | NO | | N | || Process_priv | enum('N','Y') | NO | | N | || File_priv | enum('N','Y') | NO | | N | || Grant_priv | enum('N','Y') | NO | | N | || References_priv | enum('N','Y') | NO | | N | || Index_priv | enum('N','Y') | NO | | N//查看建表语句mysql> show create table user\G;*************************** 1. row ***************************Table: userCreate Table: CREATE TABLE `user` (`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',6. 查看当前用户mysql> select user();+----------------+| user() |+----------------+| root@localhost |+----------------+1 row in set (0.00 sec)7.查看当前使用的数据库mysql> select database();+------------+| database() |+------------+| mysql |+------------+1 row in set (0.00 sec)8.创建库mysql> create database db1;Query OK, 1 row affected (0.00 sec)9. 创建表mysql> create table t1(-> id int(4),-> name char(40)-> );Query OK, 0 rows affected (0.01 sec)10.查看当前数据库版本mysql> select version();+-----------+| version() |+-----------+| 5.6.47 |+-----------+1 row in set (0.00 sec)11.查看数据库状态mysql> show status;+-----------------------------------------------+-------------+| Variable_name | Value |+-----------------------------------------------+-------------+| Aborted_clients | 0 || Aborted_connects | 8 || Binlog_cache_disk_use | 0 || Binlog_cache_use | 0 || Binlog_stmt_cache_disk_use | 0 || Binlog_stmt_cache_use | 0 || Bytes_received | 1071 || Bytes_sent | 27483 || Com_admin_commands | 0 || Com_assign_to_keycache | 0 || Com_alter_db | 0 || Com_alter_db_upgrade | 0 |12.查看各参数mysql> show variables;show variables like'max_connect%';456 rows in set (0.00 sec)+--------------------+-------+| Variable_name | Value |+--------------------+-------+| max_connect_errors | 100 || max_connections | 151 |+--------------------+-------+2 rows in set (0.00 sec)13.修改参数mysql> set global max_connect_errors=1000;Query OK, 0 rows affected (0.00 sec)14. 查看队列mysql> show processlist;show full processlist;+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+| Id | User | Host | db | Command | Time | State | Info |+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+| 1 | system user | | NULL | Connect | 7370 | Connecting to master | NULL || 2 | system user | | NULL | Connect | 7370 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL || 17 | root | localhost | NULL | Query | 0 | init | show processlist |+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+------------------+3 rows in set (0.00 sec)+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+| Id | User | Host | db | Command | Time | State | Info |+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+| 1 | system user | | NULL | Connect | 7370 | Connecting to master | NULL || 2 | system user | | NULL | Connect | 7370 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL || 17 | root | localhost | NULL | Query | 0 | init | show full processlist |+----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+3 rows in set (0.00 sec)
若有收获，就点个赞吧
0 人点赞
