Sometimes we decide that we need to clear a table from the database. In fact, if we can't do that, that would be a big problem, because the database Administrator-DBA is bound to be unable to manage the database efficiently. Fortunately, SQL has the
The purpose of the UNION all directive is to merge the results of the two SQL statements together. the union All and union differ in that union all lists each qualifying material, regardless of whether the data value is duplicated or not.The syntax
In SQL, the in command is used in two cases , and this page describes one of them-the one that is related to where . In this usage, we have already known at least one of the values we need, and we put these known values in this clause. The syntax
mkdir: Creating an empty Directory1. Command formatmkdir [Options] directory ...2. Command functionCreates an empty directory at the specified location, the command must have writable permissions, and cannot create a directory with a name that
1. fdisk [-l] appliance Name: View disk partition, or disk partition, parameters:-L: Outputs all the partition contents of the device after the output . If only fdisk–l is available, the system will list the partition of the devices that can be
As a system administrator to monitor the system in real time, prevent and timely solve the system failure, maximize the performance of the system and always keep an eye on the system security.Basic tasks for Linux system administrators1. User
. The block layer entry function is Genhd_device_init (), which begins the analysis of the function: function to implement the source code: static int __init genhd_device_init (void){Bdev_map = Kobj_map_init (Base_probe,
functions: divided into clients and servers, the client can transfer strings to the server and transfer files.Environment:UbuntuCompile method:server.c: gcc –o server server.c Client.c:gcc-o Client Client.cHow to run:Open two terminals, run at one
One. First write a shell script, script name: Nginx#! /bin/bash# chkconfig:35 85 15# Description:nginx is an HTTP (s) server, HTTP (s) reverseSet-ePath=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bindesc= "Nginx Daemon"Name=nginxdaemon=/
Installed Linux optimization1. Change the Yum source generally I use 163Vim/etc/yum.repos.d/centos.repo(or you can go directly to the download. Repo this file)(Be sure to back up the file before you modify it. bak)2. Upgrading the SystemYum
SecureCRT : [1]securecrt color scheme "Go"?? ?? SECURECRTis a supportSSH(SSH1and theSSH2) of the terminal emulator, simply said to beWindowsunder LoginUNIXorLinuxthe software for the server host. SecureCRTSupportSSH, while supportingTelnetand
http://blog.csdn.net/spring21st/article/details/8621343Linux View Port occupied and killedCategory: LAMP 2013-02-28 12:01 464 people read reviews (0) Favorite reports1. Check the port number usage:[Plain] View plaincopyNetstat-apn|grep 80TCP 0 0 10.6
Serial number
Command
Description
1
sudo su
Switch from normal user to root user
2
SU user
switch from root user to normal user
3
Ls
Lists the files and directories of
Turn from:Http://www.cnblogs.com/NeilHappy/archive/2012/12/08/2808417.html# include int gettimeofday (struct timeval *tv,struct timezone *tz);Strut Timeval {Long tv_sec; /* Number of seconds */Long tv_usec; /* microsecond number */};Gettimeofday
In the afternoon, the plan 2 hours to fix, the personal official website 6th times upgrade, can do a bit of easy things, the result, more than 2 hours in the afternoon, in the evening and engaged in 2 hours, just fix. The last world problem is that
Solve the Problem of FSTAB file read-only in Linux, and the linuxfstab file is read-only.
Fault Cause:
After modifying/etc/fstab, mount a swap partition as ext3, so the machine cannot start normally.
Solution:
Enter the root password as prompted
Linux lab-shell programming
1. view the values of environment variables defined by the user shell in the current system.2. Define the value of the variable AK to 200 and display it on the screen.3. Define the value of the variable AM to 100, and
An error occurred while installing software in Linux.Root @ youhaidong-Edge-E545:/home/youhaidong # apt-get install install_flash_player_11_linux.x86_64.tar.gzReading the package list... completeAnalyzing the dependency tree of the software
Reset root Password in CentOS
Retrieve the root password locally in CentOS
Speaking of system passwords, it may be the biggest headache for administrators. If there are many internal services, You need to record a lot of passwords. Of course, the
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