LinuxÌṩÁË´óÁ¿µÄÃüÁÀûÓÃËü¿ÉÒÔÓÐЧµØÍê³É´óÁ¿µÄ¹¤×÷£¬Èç´ÅÅ̲Ù×÷¡¢Îļþ´æÈ¡¡¢Ä¿Â¼²Ù×÷¡¢½ø³Ì¹ÜÀí¡¢ÎļþȨÏÞÉ趨µÈ¡£ËùÒÔ£¬ÔÚLinuxϵͳÉϹ¤×÷Àë²»¿ªÊ¹ÓÃϵͳÌṩµÄÃüÁî¡£ÒªÏëÕæÕýÀí½âLinuxϵͳ£¬¾Í±ØÐë´ÓLinuxÃüÁîѧÆð£¬Í¨¹ý»ù´¡µÄÃüÁîѧϰ¿ÉÒÔ½øÒ»²½Àí½âLinuxϵͳ¡£
²»Í¬Linux·¢ÐаæµÄÃüÁîÊýÁ¿²»Ò»Ñù£¬µ«Linux·¢Ðа汾×îÉÙµÄÃüÁîÒ²ÓÐ200¶à¸ö¡£ÕâÀï±ÊÕ߰ѱȽÏÖØÒªºÍʹÓÃÆµÂÊ×î¶àµÄÃüÁ°´ÕÕËüÃÇÔÚϵͳÖеÄ×÷Ó÷ֳÉÏÂÃæÁù¸ö²¿·ÖÒ»Ò»½éÉÜ¡£±¾ÎÄÖ÷Òª²Î¿¼²ÜÔªÆäÏÈÉúµÄ¡¶Linux±ØÑ§µÄ60¸öÃüÁî¡·¡£
¡ô °²×°ºÍµÇ¼ÃüÁlogin¡¢shutdown¡¢halt¡¢reboot¡¢install¡¢mount¡¢umount¡¢chsh¡¢exit¡¢last£»
¡ô Îļþ´¦ÀíÃüÁfile¡¢mkdir¡¢grep¡¢dd¡¢find¡¢mv¡¢ls¡¢diff¡¢cat¡¢ln£»
¡ô ϵͳ¹ÜÀíÏà¹ØÃüÁdf¡¢top¡¢free¡¢quota¡¢at¡¢lp¡¢adduser¡¢groupadd¡¢kill¡¢crontab£»
¡ô ÍøÂç²Ù×÷ÃüÁifconfig¡¢ip¡¢ping¡¢netstat¡¢telnet¡¢ftp¡¢route¡¢rlogin¡¢rcp¡¢finger¡¢mail¡¢ nslookup£»
¡ô ϵͳ°²È«Ïà¹ØÃüÁpasswd¡¢su¡¢umask¡¢chgrp¡¢chmod¡¢chown¡¢chattr¡¢sudo ps¡¢who£»
¡ô ÆäËüÃüÁtar¡¢unzip¡¢gunzip¡¢unarj¡¢mtools¡¢man¡¢unendcode¡¢uudecode¡£
LinuxÃüÁîÕûÀí£¨1£© ......
Ò»¡¢forkÈëÃÅ֪ʶ
ÏÈ¿´Ò»¸öÀý×Ó£º
/*
* fork_test.c
* version 1
* Created on: 2010-5-29
* Author: wangth
*/
#include <unistd.h>;
#include <stdio.h>
int main ()
{
pid_t fpid; //fpid±íʾforkº¯Êý·µ»ØµÄÖµ
//´Ëʱ½öÓÐÒ»¸ö½ø³Ì
fpid=fork();
//´Ëʱ²Ù×÷ϵͳÖÐÒѾÓÐÁ½¸ö½ø³ÌÔÚͬʱÔËÐÐ
if (fpid < 0)
printf("error in fork!");
else if (fpid == 0)
printf("I am the child process, my process id is %d\n",getpid());
else
printf("I am the parent process, my process id is %d\n",getpid());
return 0;
}
ÔËÐнá¹ûÊÇ£º
I am the parent process, my process id is 2365
I am the child process, my process id is 2367
Ò»¸ö½ø³Ì£¬°üÀ¨´úÂë¡¢Êý¾ÝºÍ·ÖÅ䏸½ø³ÌµÄ×ÊÔ´¡£fork£¨£©º¯Êýͨ¹ýϵͳµ÷Óô´½¨Ò»¸öÓëÔÀ´½ø³Ì¼¸ºõÍêÈ«ÏàͬµÄ½ø³Ì£¬Ò²¾ÍÊÇÁ½¸ö½ø³Ì¿ÉÒÔ×öÍêÈ«ÏàͬµÄÊ£¬µ«Èç¹û³õʼ²ÎÊý»òÕß´«ÈëµÄ±äÁ¿²»Í¬£¬Á½¸ö½ø³ÌÒ²¿ÉÒÔ×ö²»Í¬µ ......
ÆäʵLinuxÏÂSVN»¹ÊDZȽϼòµ¥£¬ ÔÚÍøÉÏ£¬ Ò»ËѾÍÊÇÒ»´ó°ÑµÄ×ÊÁÏ¡£ µ«ºÜÉÙÓÐÈËÒ»´Î°²×°³É¹¦£¬ ÒòΪLinuxÖеĻ·¾³Ì«¸´ÔÓ£¬
ºÜÈÝÒ×»·¾³³åÍ»¡£
linux svnÒ»°ãÒÀÀµÓÚhttpd£¨Apache Web·þÎñÆ÷£©.
svn¶ÀÁ¢·½Ê½
µ±È»svn»¹ÓжÀÁ¢·½Ê½£¬ ¼´²»ÐèÒªapache·þÎñÆ÷, ¼´Ìø¹ýÏÂÃæµÄapache°²×°£¬ ¼°ÅäÖÃÖйØÓÚhttpd.conf²¿·Ö¡£
ÔÚ±àÒësubversionʱ
$./configure -prefix=/opt/svn -without-berkeley-db -with-zlib
(×¢£ºÒÔsvnserve·½Ê½ÔËÐУ¬²»¼Óapache±àÒë²ÎÊý¡£ÒÔfsfs¸ñʽ´æ´¢°æ±¾¿â£¬²»±àÒëberkeley-db)
°²×°apache
¼ì²éapacheÊÇ·ñ°²×°¡£
Ò»°ãserver·¢ÐаæµÄlinux»á¸½´øapache web ·þÎñÆ÷¡£ ËùÒÔÐèÒªÏÈ¿´¿´ÊÇ·ñ°²×°ÁËapache£¬ ¼°°²×°µÄ°æ±¾ºÅ¡£
ͨ¹ý¿ÉÖ´ÐÐÎļþÊÇ·ñ´æÔÚ£º ÔÚµ±Ç°Â·¾¶Ï£¬ תÈë $ httpd(apachectl) -v, Èç¹û´æÔÚ£¬ ÄÇôÊäÈë$
whereis httpd(apachectl), ÕÒ³öÆä·¾¶£¬ ÔÙͨ¹ý$ fileÃüÁî²éÆä°²×°Â·¾¶¡£Èç¹û²»´æÔÚÃüÁî;
ÄÇô¼ì²é/etc/init.d/httpdÊÇ·ñ´æÔÚ£¬ Èç¹û´æÔÚ£¬ ²é¿´°²×°Â·¾¶¡£ ͨ¹ývi(m)µÈ¹¤¾ß²é¿´ÆäÄÚÈÝ£¬ ¿ÉÒÔÕÒµ½Â·¾¶¡£
ͨ¹ý·¢Ðаü¹¤¾ß¼ì²é£¬ ÈçÔÚradhat(fedora)ϵͳÖУ¬ ʹÓõÄÊÇrpm»òyum,
Debian(°üÀ¨ubuntu)µÄdpkg»òapt-get¹¤¾ß, Su ......
SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÉÏ) -¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:29:44)
×ªÔØ
·ÖÀࣺÉî¶ÈÑо¿
´ó¼Ò¶¼ÖªµÀLIKE²éѯºÜÂý£¬È«ÎÄË÷Òý¾ÍÊÇÊÂÏÈ×öºÃÏà¹ØµÄË÷Òý£¬±íʾÄĸöÖ÷Ìâ´Ê¿ÉÒÔÔÚÄÄЩ¼Ç¼ÀïÕÒµ½£¬ÉõÖÁÊÂÏȼÆËãºÃRANK£¬¼ìË÷ʱ¿ÉÒÔ°ÑÏà¹Ø¶È¸ßµÄÏÈÁгöÀ´£¬Õâ¿ÉÒÔ´ó´óÌá¸ß¼ìË÷µÄËÙ¶È¡£
´ò¸ö±È·½£¬ÄãÓкܶàµÄС³éÌ룬ÿ¸ö³éÌëÀïÃæ·ÅһЩÔÓÎ¼ÙÈçÄãÒªÕÒ¶«Î÷£¬×îÔʼµÄ·½·¨¾ÍÊÇÒ»¸ö¸ö³éÌë·£¬Õâ¾ÍÊÇûÓÐË÷ÒýµÄÇé¿ö¡£
¼ÙÈç´ÏÃ÷Ò»µã£¬¸ø³éÌë±àºÅ(Ψһ¼ü)£¬°ÑÄĸöºÅÂëµÄ³éÌëÓÐʲô¶«Î÷¼Ç¼ÔÚÖ½ÉÏ£¬ÕÒ¶«Î÷ÏÈ¿´¿´ÕâÕÅÖ½£¬Õâ¾ÍÊÇÆÕͨË÷Òý£¬¼ÙÈçÄãÒªÖªµÀÄĸö³éÌëÓÐʲô£¬Äã¿ÉÒÔÔÚÖ½ÉÏѸËÙÕÒµ½³éÌëºÅÂë(´ó¼ÒÖªµÀÕâÊÇʹÓòéÕÒÊ÷)£¬È»ºóµÃµ½Ïà¹ØµÄÐÅÏ¢£¬ÕâÖÖÇé¿öÆÕͨË÷ÒýÊǺܿìµÄ£»µ«ÊÇÒªÕÒµ½Ò»¸öÌØ¶¨µÄ¶«Î÷ÄÄЩ³éÌëÓУ¬Äã¾ÍÒª°ÑÕûÕÅÖ½±éÀúÒ»´Î£¬Õâ¾ÍÊÇLIKE²éѯ£¬¼ÙÈçÄãÒªÕÒÄÄЩ³éÌëͬʱÓÐ2ÖÖÉõÖÁ¸ü¶àÖÖÎïÆ·£¬LIKE¾Í¸ü¼Ó·±ËöÁË¡£¼ÙÈçÒ»¸ö±íÓÐÉÏǧÍòµÄ¼Í¼£¬´ó¼Ò¿ÉÒÔÏëÏó²éѯµÄ´ú¼Û¡£
¿ÉÒÔ»»Ò»¸ö˼·£¬ÁíÍâÕÒÕÅÖ½£¬¼Ç¼һÑù¶«Î÷´æÔÚÓÚÄÄЩ³éÌ룺
¼Ð×Ó:1,3,4,5,6,9,12...
Ç®±Ò:2,3,4,7,12...
Ò©Íè:1,3,5,6...
ÕâÑùÕÒµ½Ä³Ñù¶«Î÷»òÕßij¼¸Ñù¶«Î÷¶¼ºÜÈÝÒס£
È«ÎÄË÷ ......
SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ)-¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:32:01)
×ªÔØ
·ÖÀࣺÉî¶ÈÑо¿
ÔÚʹÓÃSQL SearchµÄ¹ý³ÌÖУ¬»¹·¢ÏÖÁËÒ»¸öÎÊÌ⣺Ëü¶ÔÖÐÎÄ£¬Êǰ´×ִַʵģ¬ÏÂÃæÎÒ½âÊÍһϣº
±ÈÈç¶Ô'²©¿ÍÌóÉÔ±ºÜ¶àÊÇMVP'Õâ¾ä»°£¬¼ÙÈçÒ»¸ö¸öµÄ×ÖµÄ×÷Ë÷Òý£¬»á±ÈʹÓÃ'²©¿ÍÌÃ','³ÉÔ±',MVP'¼¸¸ö´Ê×÷Ë÷ÒýÉú³ÉµÄË÷Òý´óºÜ¶à£¬ÕâÑù²»½öÀ˷ѿռ䣬ҲӰÏìË÷ÒýµÄЧÂʺÍ׼ȷ¶È¡£¼ÙÈçÓ¢ÎÄÊǰ´ÕÕ×Öĸ¶ø²»Êǵ¥´Ê×÷Ë÷Òý£¬¹À¼ÆÊÀ½çÉÏÈç½ñ¾ÍûÓÐÈ«ÎÄË÷Òý£¬Ò²Ã»ÓÐgoogleÁË¡£
µ«ÊÇÖÐÎÄÔÚ·Ö´ÊÉÏ£¬Ïà±ÈÓ¢ÎÄÓÐÌìÈ»µÄÆÁÕÏ£¬Ó¢Îĵĵ¥´ÊÖ®¼äÓмä¸ô£¬µ«ÊÇÖÐÎIJ»ÊÇ£¬±ØÐëʹÓüÆËã»úµÄÈ˹¤ÖÇÄܰѾä×Ó·Ö³ÉÒ»¸ö¸öµÄ´Ê£¬ÓÐЩʱºò£¬¸ù¾Ý¾ä×Ó±¾Éí»¹²»¹»£¬»¹±ØÐë¸ù¾ÝÉÏÏÂÎÄ£¬»òÕßһЩÈÕ³£ÖªÊ¶²ÅÄÜÅжϡ£±ÈÈç Æ¹ÅÒÇòÅÄ/Âô/ÍêÁË ºÍ ƹÅÒÇò/ÅÄÂô/ÍêÁË £¬µçÄÔÕ¦ÄÜÖªµÀÊÇÄĸöÒâ˼²¢ÕýÈ··Ö´ÊÄØ£¡
¸ù¾ÝʹÓõĽá¹û£¬SQL Search¶ÔÖÐÎÄʹÓõÄÓ¦¸ÃÊǰ´×Ö·Ö´Ê(¿ÉÄÜÊÇÒòΪÔÀ´ÊÇÓ¢ÎÄÒýÇæµÄÔµ¹Ê)£¬±È·½ËµÄãÒª²é'Âí¿Ë'£¬Ëü»á°Ñ'Âí¿Ë˼'Ò²¸øÄãµ¹ÌÚ³öÀ´¡£
ÎÒµÄÒ»¸ö123MµÄÊý¾Ý¿â£¬È«ÎÄË÷ÒýÓÐ55M£¬Ã¿´ÎÈ«ÎIJéѯ¶¼±È½ÏÂý(µ±È»»úÆ÷Ò²ºÜ´Î)¡£
-------------------------------------------------------------------- ......
ÕâÖÖÓ÷¨ÏàÐÅÔÚÍøÕ¾Öо³£Ê¹Óã¬ÈçÒªÔÚ±íÖÐËæ»úÈ¡³ö10Ìõ¼Ç¼£¬Èç¹ûʹÓñà³ÌÓïÑÔ½øÐÐÔËËãµÄ»°»áºÜÂé·³¶øÇÒЧÂʵÍÏ¡£ÔÚSql ServerÖÐ×Ô´øÁËrandom()º¯ÊýÓÃÓÚÉú³ÉËæ»úÊý£¬ÆäʵËü»¹×Ô´øÁËÁíÍâÒ»¸öËæ»úº¯Êýnewid();newid()ÔÚɨÃèÿÌõ¼Ç¼ʱ¶¼»áÉú³ÉÒ»¸öËæ»úµÄÖµ£º
Ö´ÐÐselect newid()£»ÔËÐнá¹û
¿ÉÒÔ¿´µ½Õâ²¢²»ÊÇÒ»¸öËæ»úµÄÊý×ÖÀàÐÍ¡£
ÔÚ±íÖÐËæ»úÈ¡³önÌõ¼Ç¼£¬¾Í¿ÉÒÔʹÓÃselect top n * from table order by newid()ʵÏÖ£»
......