MySQL Command line learning

1. Log in to MySQL

Local: Mysql-u root-p, enter the password after the return; You can also add a password directly after p without a space. Enter and sign in.

Remote: Mysql-hxx.xx.xx.xx-u-pxxx

2, view the database: show databases;

3, connect the database: use db_name;

4. View Data sheet: show tables;

5, query: SELECT * FROM table_name where xxx and XXX;

6, the current selection of databases: Select database ();

7, query MySQL version: select version ();

8, Current time: Select Now (); or select Current_timestamp ();

9, printing date: SELECT day/month/year (current_date);

10. Print characters: Select "I am Danny.yao";

11. View Table structure: Describe < table name >;

12. Details of all the current connections: Show full processlist; (not full, show only the first 100 connections)

13. View status: Show state like '% under variable% ';

Aborted_clients the number of connections that have been discarded because the client did not properly close the connection already dead.
Aborted_connects the number of times the connection to the MySQL server has failed.
Connections the number of attempts to connect to the MySQL server.
Created_tmp_tables the number of suppressed temporary tables that have been created when the statement is executed.
Delayed_insert_threads the number of deferred plug-in processor threads being used.
Delayed_writes the number of rows written with the insert Delayed.
Delayed_errors the number of rows written with insert Delayed for some errors (possibly repeating key values).
Flush_commands the number of times the flush command was executed.
Handler_delete the number of times a row was requested to be deleted from a table.
The number of times the Handler_read_first request reads the first row in the table.
The Handler_read_key requests a number based on the key read line.
The number of times a handler_read_next request reads into a row based on one key.
The number of times a HANDLER_READ_RND request reads into a row based on a fixed position.
Handler_update the number of times a row in the table was requested to be updated.
The number of times the Handler_write request inserts a row into the table.
key_blocks_used the number of blocks used for the keyword cache.
Key_read_requests the number of times a key value was requested to be read from the cache.
Key_reads the number of times a key value has been physically read from disk.
Key_write_requests requests a keyword block to be written to the cache count.
Key_writes the number of times a key-value block is physically written to disk.
Max_used_connections the maximum number of connections that are used at the same time.
Not_flushed_key_blocks a key block that has been changed in the key cache but has not been emptied to disk.
Not_flushed_delayed_rows the number of rows waiting to be written in the Insert delay queue.
Open_tables the number of open tables.
Open_files the number of open files.
Open_streams Number of open streams (primarily for log records)
Opened_tables the number of tables that have been opened.
Questions the number of queries destined for the server.
Slow_queries the number of queries that will take more than long_query_time time.
threads_connected the number of connections currently open.
Threads_running the number of threads that are not sleeping.
Uptime How many seconds the server has worked.

MySQL Command line learning