摘要：::完整备份declare @filename nvarchar(100) set @filename='e:\\databack\\data'+convert(char(8),getdate(),112)+'.bak' print @filename BACKUP DATABASE [local] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'aWkSQLBAK', NOSKIP, STATS = 10, NOFORMAT::完整备份基础上进行差异备份declare @filenam 阅读全文

摘要：1.查询某一列或多列的重复记录，只能查出重复的值，不能列出整条记录的信息selectid,name from tbgroupby id,namehaving(count(*))>12.查询某一列重复的记录，并列出全部select*from tbwhereid in (select stuid from stuinfogroupby stuidhaving(count(*))>1)3.查询某一列重复的记录，列出多余的记录，比如重复三条，列出多余的两条前提：需要有一个不重复的列，例如下例中的recno,重复的是stuidselect*from stuinfo s1where recno 阅读全文

摘要：1.查询可用数据库，排除系统库select * from sysdatabases where dbid>42.查询可用表，排除系统表select * from sysobjects where xtype='u'3.删除/建立数据库drop/create database students;4.删除/新建表drop table tablename;create table tb (id int,name varchar(20),sex varchar(20))5.插入记录insert into tb (id,name,sex) values ('1',& 阅读全文

摘要：1.全局环境变量/etc/profile2.特定用户环境变量在用户home目录下的.bash_profile诸如/home/oracle/.bash_profile3.临时环境变量export PATH=/usr/local/webuserver/php/bin:$PATH 阅读全文

摘要：insert into tongxunlu (name,address,email) select sname,saddress,semail from students;select students.sname,students.saddress,students.semail into tongxunlu from students;select students.sname,students.saddress,students.semail,identity(int,1,1) as studentid into tongxunlu from students;update studen 阅读全文

摘要：%java_home%../,,/,,/database%windir%../../ 阅读全文

摘要：mysqld_safe --user=mysql --skip-grant-tables --skip-networking &;myisamchk -c -r /var/lib/mysql/mysql/user.MYI 阅读全文

摘要：1.sharemount -t cifs -o username=awk,password=nayezi312 //192.168.1.133/Pbw$ /mnt/share2.usblsusbfdisk -lmount -f ntfs-3g /dev/sdb1 /mnt/udisk3.harddiskll /dev/disk/by-pathdf -hfdisk -lfdisk /dev/sdbmake.ext4 /dev/sdbmkdir /datamount /dev/sdb /dataecho "/dev/sdb1 /data ext4 defaults 0 0" & 阅读全文

摘要：select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;grant select,update,insert,delete on *.* to root@192.168.1.133 identified by "root";select host,user.password from user; 阅读全文

摘要：for /f "tokens=1-3 delims=.: " %%1 in ("%time%") do set ttt=%%1%%2%set /a ttt=%ttt%+2for /f "tokens=1-3 delims=- " %%1 in ("%date%") do set ttt=%ttt%%%3%%2%set ttt=%ttt:~1,-1% 阅读全文

摘要：#!/bin/bashDB_NAME="test"DB_USER="username"DB_PASS="password“BIN_DIR="/usr/local/mysql/bin"BCK_DIR="/home/mysql/backup"DATE=`date+%F`$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME|gzip>$BCK_DIR/db_$DATE.gz 阅读全文

摘要：while read linedoecho "Good!"done<file 阅读全文

摘要：umount /mnt/cdromfuser -m /mnt/cdromkill -9 user 阅读全文

摘要：find . -type f -name "*.txt" -print0 | xargs -0 rm -f 找出所有TXT文件并以空格列出，然后按空格为定界符进行删除操作。find sourc_code_dir_path -type f -name "*.c" -print0 | xargs -0 wc -l 统计C程序文件的总行数。 阅读全文

摘要：find . -type d -print 目录find . -type f -print 普通文件find . -type -print 符号链接find . -type f -atime -7 -print 七天内被访问过的所有文件find . -type f -atime 7 -print 恰好七天前被访问过的所有文件-amin,-mmin,-cmin参数对应分钟。另外，find . -type f -size +2k 大于2k的文件。find . -type f -perm 644 -print 打印权限为644的文件。find . -type f -name "*.swp& 阅读全文

摘要：find /home/slynux -name "*.txt" -printfind . -iname "example*" -print 忽略大小写find . \(-name "*.txt" -o -name "*.pdf" \) -print\...\把中间的部分视为一个整体。-path 允许使用通配符类匹配文件路径或文本。find /home/users -path "*slynux*" -printfind . -iregex ".*\(\.py\ | \.sh\)$&quo 阅读全文

摘要：find . -printfind . -print0 阅读全文

摘要：echo -n Count;tput sccount=0;while true;doif [ $count -lt 40 ];then let count++;sleep 1;tput rctput edecho -n $count;else exit 0;fidone 阅读全文

摘要：start=$(date +%s)commands;statements;end=$(date +%s)difference=$(( end - start ))echo Time taken to execute commands is $difference seconds. 阅读全文

摘要：echo -e "\e[1;31m This is red text \e[0m" 阅读全文

摘要：sqlplus / as sysdba;alter user test account lock;alter user test account unlock; 阅读全文

摘要：1./etc/passwd,/etc/shadow,/etc/group/etc/passwd username:passwd:uid:gid:describe:directory:shell/etc/group groupname:passwd:groupid:groupuser /etc/shadow login:passwd:last:min:max:warn:inactive:lost 2. userdel: user newnameis currently logged in wpkill -kill -t pts/1userdel -f 3.file exist,but user 阅读全文