Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to view configuration parameters and get help from mysql

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Here's how mysql looks at configuration parameters and gets help. The secret of the text is to be close to the topic. So, forget the gossip, let's go straight to the following, and I'm sure you'll benefit from reading this article on how to check configuration parameters and get help from mysql.

View configuration parameters:

SHOW VARIABLES LIKE'% timeout%'

2) help that comes with MySQL client tools

? (?) Synonym for `help'.

Clear (\ c) Clear the current input statement. -- clear the currently entered statement

Connect (\ r) Reconnect to the server. Optional arguments are db and host. -- reconnect, usually used to reconnect after being deleted or disconnected abnormally

Delimiter (\ d) Set statement delimiter. -- set the command Terminator, which defaults to;, for example, we can set it to / to indicate the end of the statement

Edit (\ e) Edit command with $EDITOR. Edit the last SQL statement of the buffer to the file, call vi by default, and the file will be placed under the / tmp path

Ego (\ G) Send command to mysql server, display result vertically. -- the control result is displayed vertically

Exit (\ Q) Exit mysql. Same as quit. -- exit mysql

Go (\ g) Send command to mysql server. -- send commands to the mysql service

Help (\ h) Display this help.

Nopager (\ n) Disable pager, print to stdout. -- turn off page settings and print to standard output

Notee (\ t) Don't write into outfile. -- turn off output to file

Pager (\ P) Set PAGER [to_pager]. Print the query results via PAGER. -- set pager mode, which can be set to call more,less, etc., mainly for paging display

Print (\ p) Print current command.

Prompt (\ R) Change your mysql prompt. -- change the prompt for mysql

Quit (\ Q) Quit mysql.

Rehash (\ #) Rebuild completion hash. -- automatically complete the names of related objects

Source (\.) Execute an SQL script file. Takes a file name as an argument. -- execute script files

Status (\ s) Get status information from the server. -- get status information

System (\!) Execute a system shell command. -- execute system commands

Tee (\ T) Set outfile [to_outfile]. Output the results of Append everything into given outfile.-- operation to file

Use (\ u) Use another database. Takes database name as argument. -- switching databases

Charset (\ C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. -- set character set

Warnings (\ W) Show warnings after every statement. -- print warning messages

Nowarning (\ w) Don't show warnings after every statement.

3. Related help from the server.

-- get help related to CVM management and enter help contents

Mysql > help contents

Is there anything you don't understand about how to check the configuration parameters and get help from the above mysql? Or if you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report