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 [,
Method One: Set the terminal BACKSPACE to ASCII 127Method Two: Use CTRL + BACKSPACE keyPress CTRL + BACKSPACE key at the same time to delete.Method Three: Use Ctrl+w to send signals to delete entire wordsDirectly send the deletion of the whole word
Alias gives the command a nickname$ C= ' Clear 'CD changes the current path$ cd/etc Change the current path to/etc $ CD back home directory $ CD. Go back to the previous level directory $ CD-back to the directory you just went toCP Copy files or
in the recent completion of the teacher's assignments encountered how to let the shell script command automatically determine whether a user has set the password problem, although seemingly not a difficult problem, but in the process of
When we use the shell to process files, we often need to remove or add newline characters, the name of the problem is how to quickly replace it?We have such a file[email protected] working]# cat
#!/bin/bashecho "Hello world!"1. As an executable programSave the above code as test.sh and CD to the appropriate directory:chmod u+./test. #使脚本具有执行权限 ./test. #执行脚本2. As an interpreter parameterThis works by running the interpreter directly, whose
Edit the. bash_profile file under your own user#. Bash_profile#exportPs1= "\n\e[1;32m[\e[0;31m\u\e[0;[ Email protected]\e[0;31m\h\e[1;32m]\e[1;32m[\e[0;34m\w\e[1;32m]$ "# Get the aliases and functionsIf [-f ~/.BASHRC]; Then. ~/.bashrcFi# User
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称,
#本人新手写的不好之处, be sure to advise me. I will update this content on an irregular basis.1. Enter the IP address to find the domain name specified in the/etc/hosts file#!/bin/sh#author VPERSON#QQ 737304790#enter The specified IP to find the corresponding
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
Scrapy shell command1.scrapy Shell URL #url指你所需要爬的网址2. Some URL data crawling needs user-agent,scrapy shell can directly add header files,Section ① MethodsScrapy shell-s user_agent= "mozilla/5.0 (Windows NT 6.1) applewebkit/537.36 (khtml, like Gecko)
Shell script Detailed definitionA "program" written using the shell's function, which is a plain text file, can write some shell syntax and commands (including external commands) in it, with regular expressions, pipe commands, and data flow
Usually write scripts are not used in several groups, temporarily first record the usage.#!/bin/Basharray1=(1 2 3 4 5) Array1_length=${#array1 [@]}Echo "array1 Length: ${array1_length}" forIteminch${array1[@]} Do Echo "Current item of array1:
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