摘要： 1,su - db2inst2,db2 connect to ids3,db2stop force4,db2 list db directory5,db2 list tables for all6,db2 describe table tablename7,db2 "restore db JVC f... 阅读全文

摘要： for /r %%i in (*.bat) do copy "d:\kkk.txt"/a+"%%i"/a "d:\kkk.txt" 阅读全文

摘要： updatemem_memberaccountsetlevel='4'whereidin(selectidfrommem_memberbaseinfowherelevelname=(selectnamefrommem_chainmemberlevelwherelevel='4')); updatem... 阅读全文

摘要： grant all privileges on *.* to root @192.168.88.222 identified by 'hint123'; 阅读全文

摘要： #!/bin/bashread -p "Please enter the identify:" useridmysql -uroot -p111111 pwchain -e "delete from mem_memberaccount where id=(select id from mem_mem... 阅读全文

摘要： mount|grep home;vi /etc/fstabLABEL=/home /home ext3 defaults,usrquota,grpquota 1 2umount /homemount -aquotacheck -avugll -d /home/a*quotaon -auvgquotaoff edquota -u myquota1edquota -p myquota1 -u myquota2edquota -g myquotagrpedquota -tquota -uvs myquota1 myquota2quota -gvs myquotagrprepquota -auvs 阅读全文

摘要： grant all privileges on *.* to 'root' @ '%' identified by '123';flush privileges;use mysql;select * from user; 阅读全文

摘要： 1.grub单用户模式grub edit>kernel /vmlinuz-2.6.18-95.e15 ro root=LABLE=/ rhgb quiet single2.避过inittabgrub edit>kernel /vmlinuz-2.6.18-95.e15 ro root=LABLE=/ rhgb quiet init=/bin/bashmount -o remount、rw / 将根目录重新挂载为读写 阅读全文

摘要： kill -SIGHUP $(ps aux|grep 'syslog'|grep -v 'grep'|awk '{print $2}')以ps找出syslog这个进程的PID后，再使用kill传送信息，使得syslog可以重新读取配置文件。以上命令等同于kill -1 $(ps aux|grep 'syslog'|grep -v 'grep'|awk '{print $2}'). 阅读全文

摘要： update mem_memberaccount set level=4 where id in (select id from (select a.id,a.uniqueid,a.levelname,b.level from mem_memberbaseinfo a,mem_memberaccount b where a.id=b.id) x where level='5' and levelname'vip'); 阅读全文