Flexible combination of Linux/unix shell and SQL variable transfer, greatly improve the efficiency of the DBA, this article for Linux/unix Shell SQL passed between the variables given a few simple examples for reference.Linux/unix cut with Sql,ramn
#!/bin/shFor1 () {For I in 1 2 3 4 5 6Doecho "$i"Done}For1#!/bin/shFor2 () {For i in {1..10}Doecho "$i"Done}For2#!/bin/shFor3 () {Sum=0#int =1For i in {1..100..2}DoLet "Sum+=i"Doneecho "Sum is $sum"}For3#!/bin/shFor4 () {Sum=0For I in $ (SEQ 1 2 100)
Filter GawkGawk is a language that can perform pattern scanning and data processing. Gawk searches for one or more files, finds records (usually rows) that match the pattern, and processes the records by performing the specified actions.
Gawk
Shell types: Bourne shell, Bourne Again shell, C shell, Korn shell, Perl shell
Users can choose their favorite shell (specified when the system administrator creates an account for the user), and in the last field of the/etc/passwd file, you can
1. Bash = Bourne Again SHell2. Terminal prompt:#普通用户 [email protected]$ #管理员用户 [email protected]#3. The shell script is usually a text file that starts with Shebang:#! /bin/bashShebang is a line of text where #! is before the interpreter path.
The shell is the shell of the operating system, a command interface for users to use the operating system, and a bridge between the user and the operating system kernel.
Shell is commonly known as shell. Refers to the software that provides the
First, IntroductionThe shell is the command-line interpreter that the user interacts with the operating system.There are many kinds of shells:bash, csh, sh, ksh 、、、The command line we saw when we waited for Linux was a bash.Two, the first
Awk-f ': ' {print $3,$4} ' 1.txtAwk-f ': ' ofs= ': ' {print $3,$4} ' 1.txtawk '/root|user/' 1.txt matches root or userawk '/(OO) +/' 1.txt one or more ooAwk-f ': ' $1~/r*o/{print $} ' 1.txt the first paragraph to match r*o, and only print the third
The recent obsession with Shell, very interested in it, today is mainly about me a beginner in the execution of shell scripts when the problem encountered:As with all languages, the learning of Linux language starts with Hellworld, so now I have
Please put the following stringstu494e222fstu495Bedf3stu49692236stu49749b91Switch to the following form:stu494=e222fStu495=bedf3stu496=92236Stu497=49b91Question 2:Echo I am Oldboy training, please put the output of each character to the order,
# Vim/mysh/ipscan.SH #!/bin/bash# Scan the local alive ipaddress# .- the- -if[-F $filename]; Then Echo "The file is exist" forNinch{ -..106}; DoHost=192.168.0. $nPing-C2 $host &>/dev/NULL if[ $? =0]; Then Echo "$host is up"
[Email protected] study]#Cat fileZhang San languageBayiZhang San MathematicsBayiJohn Doe Language theJohn Doe Mathematics -Harry LanguageBayiHarry Mathematics -Harry English -How to implement for the following sort??? Bayi Bayi the -
LL is the alias of Ls-l. You can customize aliases to accommodate certain options in place of certain commands, or you can define aliases to combine multiple commands. For example, define an RM alias RMB to automatically back up to the directory
Tag: set command; unset commandFor example: There are now two user-defined variablesName= "Andy Lau"Age=20The set command is used to view variables650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/87/EF/wKioL1fkk0CQqSUwAADT1GLzRuI190.png-wh_
Writing a script today meets a strange thing.Variable A is definedIf [-a $a];then echo "exists"; else echo "not exists"; fiResult output:ExistsIt's a blind moment, but it's going to change.If [-a "$a"]Of course, a here is a script input parameters,
1. Entering a child shell after using parentheses does not have an impact on the current shell.root#/opt/lxb/dir1# (CD/OPT/LXB/DIR2;PWD)Execution only returns a directory of/OPT/LXB/DIR2, but the current shell is still in Dir1.2, Linux under the TAB
Enterprise Shell interview questions: Get 51CTO Blog list Reverse sort exam questionsOld boys education and training institutions demand: the need to enter:Please put all the posts in the http://oldboy.blog.51cto.com address according to the
Write a bash shell scriptThe script is as follows: it is used to monitor the number of mongo connections and restart the system.#! /Bin/bash# Source/etc/profileConn = '/usr/bin/mongo -- quiet Db. serverStatus (). connectionsExitEOF`Conn1 =$ {conn #*:
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