In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.