Execute an SQL script file
SQL> Start file_name
SQL> @ file_name
We can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements in this file, we can use any of the following commands, which is similar to batch processing in DOS.
When using the laptop to go to the home and the unit, because the unit is the agent with the Internet, the home is directly connected. So every time you have to modify the agent settings of IE, although it is a trivial matter, but every time to modify is always a bit annoying, so refer to Google, wrote a script to automatically configure the agent Just connect to the LAN and you can surf the Internet.function FindProxyForURL (url,host) {if (isPlainHos
}
# Execute function
Init
CreateTable
Note:
(1) This file is used to create the tb_employeeinfo table. The generated script file name is example. SQL.
(2) The Init function is used to output information on the screen, and the CreateTable function is used to create a data table.
(3) At the end of the sh file, list al
Today, the company asked me to copy the backup files on the server to the internal server, and as long as they are up-to-date, well, what is the ideal goal of O M personnel, that is, what can be done by computers, never do it by yourself.System: centos 5.9Environment: The backup file is under/root/bak. Of course, I tested it on a virtual machine.1. Backup file environment diagram2. shell
script file is named Example.sql.(2) The INIT function is used to output information on the screen, and the CreateTable function is used to create the data table.(3) At the end of the sh file, all the functions contained in this file are listed sequentially, as the functions included in this
after the measurement product deploys the service end, because the service side has each kind of encapsulation encrypted attachment, the file and so on data, in order to safeguard the security of the information, in addition to establish the high availability backup mechanism, we can through the batch script, unifies to the system plan to carry on the local or th
Use the. vbs script, that is, the SCRIPT file, to modify the registry. If your machine does not support VBSCRIPT, read the second part. The following example is used to explain the script file:
Windows Script Host Sample
Gradle packaging android (implement external import signature file, multi-channel packaging, import ant script)
Android automatic packaging has been completed recently. Previously, it has completed packaging in the form of command lines, the original ant script packaging, and android-based SDK packaging, and implemented multi-channel packaging, later, my colleagu
IntroducedWhen performing a performance test, the Jmeter Official document declaration is not recommended in the GUI, and the command line needs to be used at this time.First Step: Environment configurationAdd the JMeter installation directory \ Bin to the system environment variable pathStep Two: Command parameters-N command-line mode-T Script path-L test Result path (JTL or CSV)-j Log Path-R Distributed execution-R remote Server list-G Generate test
After I generate a script file db. SQL with the database structure and data, I want to restore the database on another computer for programming and testing. However, when I tried to execute the script on SQL Server manager Studio, the other party told me that the file was too large to open. After some searches, it is f
A case of a batch conversion directory of File encoded shell script code.
Requirements Description:As a result of turning Linux from Windows, many original win under the GBK file needs to be converted into UTF8.
The following script only judges that a UTF8
Linux Shell Script Raiders notesChapter III: File Operations1, the production of any size file [[email protected] dd_test]#[[email protected] dd_test]# dd If=/dev/zero of=junk.data bs=1k count=1010+0 Records in10+0 Records out10240 bytes (Ten kB) copied, 0.00137023 S, 7.5 mb/s2, file system related test [-f $
"Demand Scenario": A 10000w row of file processing, multi-process processing such as the start of 100 processes simultaneously processing."Method": Split file (split), make shell script execution background process"Demo":Assuming that the handler is test.php, you need to receive parameters to process the data file path
1, execute command and script on remote host based on password and secret keySsh-t IP "CLI or shell.sh";The 2,C program implements the above functions--based on password-lessPorting the simple C program above to a different system to use the testAuthorized_keys;Copy the ~/.ssh/id_rsa.pub itself to the host that needs passwordless and append the id_rsa.pub content to the ~/.ssh/authorized_keys, then you can passwordless the login.3. Copy the SSH key to
Linux has three ways to change permissions:chmod/acl/sudo
The first two are used to change file permissions,sudo is used for more application or command execution permissions
chmod limitation is the inability to achieve multiple rights allocation (there are only three user groups), in the face of multiple permissions need to be set with ACLs
Chmodchmod (Agou) (+-) (RWX) filename
Agou represents the extent to which
is used to create the Tb_employeeinfo table, and the generated script file is named Example.sql.(2) The INIT function is used to output information on the screen, and the CreateTable function is used to create the data table.(3) At the end of the sh file, all the functions contained in this file are listed sequentiall
\\/bbs.bbb.com \/www.ccc.com \/Weblist.txt has two field, the first field is the domain name, and the second field corresponds to the URL of the site. If the first domain name is www.aaa.com/3. Batch generate script file create.sh[Email protected] webcheckes]# MoreCreate.SH #!/bin/Bash PATH=/bin: $PATH: $HOME/bin:/sbin:/usr/bin:/usr/sbin Export path#Echo$PATHusa
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.