Select Connection Query Brief:Union Union Query Second, about the internal connection Union Union Query
Function: Merge 2 or more query results together
Specific: (table 1 Query results) Union (table 2 query results)
Run: The first table 1
MySQL table optimizer Brief:first, the analysis tablesecond, the inspection tablethird, optimize the tableiv. Table Data ImportFive, lock table operationfirst, the analysis table1.1. Command:ANALYZE [No_write_to_binlog | Local]table tbl_name [,
The execution name of this program$n the nth parameter value of this program, n=1..9$* all parameters of this program, this option can have more than 9 parameters.$# the number of parameters for this program$$ the PID of this program (the current
My college classmates asked me a script question, presumably the need is to see all the ports open, but also to know the application path of each port, and to be flush with the previous data, is to add a column of data. I butt eyes, very easy, but
Method One: SHCSHC is a tool for encrypting shell scripts. Its role is to convert the shell script into an executable binary file.SHC InstallationYum-y Install SHCHow to use:Shc-r-F script-name Note: To have the-r option, the-F followed by the name
Shell
History
TAB key
Alias
Wildcard characters
Redirection function
Shellshell是一个命令解释器,提供用户和机器之间的交互;Shell 是一个用 C 语言编写的程序,它是用户使用 Linux 的桥梁。Shell 既是一种命令语言,又是一种程序设计语言。Shell
Macserver need to open remote login first. Open with: System Preferences, share check remote loginFrequently used commands are:Copy (copy native file to remote server) Scp-r Local path/file userName@192. 168. XXX. XX:/tmp#userName为远程serverusername称,
Linux Shell Program DebuggingThe shell program is debugged by adding relevant debugging options when running the program or by adding related statements to the script, allowing the shell program to display some "debug information" for reference
1. Separate each command;Note: The execution of each command will not affect the execution of other commands. In other words, each command executes,However, there is no guarantee that each command will execute successfully.2. Separate && between
#!/bin/bash#filename:ifs. SH Data="name,sex,rollon,location"oldifs=$IFSIFS= for inch $data; do Echo Item: $item Done #IFS= $oldIFSSet IFS to, number separator#!/bin/Bash#filename:fenge.SH Line="Root:x:0:0:root:/root:bin/bash"oldifs=$IFSIFS=":"
“#! Magic Number: The general specification at the beginning of the script, used to specify the interpreter to execute the contents of the script. Note: Only the first line of the script #! Valid, followed by a comment! If you do not specify an
*: wildcard, matches any character, such as LS *.txt to see all files ending in. txt?: matches any one character#: annotation characters\: escape character for converting special symbols to normal characters, such as Touch \#.txt to create a file
1. Use-X to open the Shell script tracking debugging functionEx:bash-x script.shOrSh-x script.sh2. Partial debugging of scripts using Set-x and set +x (input middle content)#!/bin/bash#filename:debug. SH for inch {1.. 6 }; Do -x echo $i
Arrays ArrayVariables: Storing the memory space of a single elementArray: A contiguous memory space that stores multiple elements, which is equivalent to a collection of multiple variables that support sparse formatting, which is a discontinuous
Method:
Kill–9 ' pgrep Java '
Use the above command to kill all Java processes running on the server at once.
Extension: The role of child shells and anti-application in shell scriptsLet's look at an example of a child shell:# Cat
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service