Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Mysql°²×°

windows주
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøÏµÍ³µÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£ 
ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data 
ÒýÓà 9 Â¥ acmain_chm µÄ»Ø¸´:
¼ì²éÒ»ÏÂÄãµÄ C:\MySQL Datafiles Ŀ¼µÄȨÏÞÉèÖá£ÊÚ¸ø everyone FULLµÄȨÏÞÈ»ºóÔÙÊÔһϡ£
ÎÊÌâÎÒ½â¾öÁË£¬¾ÍÊǰÑÄã˵µÄÕâ¸öĿ¼ÎÒ×Ô¶¨ÒåÁËÒ»¸ö£¬ÔÚdÅÌÏÂÁË£¬½á¹ûºÜ˳ÀûµÄ¾Í°²×°ÉÏÁË£¬
ллÄã¡£


Ïà¹ØÎĵµ£º

Red Hat ÏÂ °²×° Apache Mysql PHP

×¼±¸
ls  /usr/local/src   //  ÏÔʾÎļþÁбí
ls  | wc -l    //  ²é¿´µ±Ç°ÎļþĿ¼ÏÂÎļþµÄ¸öÊý
gcc -v   // ²é¿´±àÒ빤¾ßÊÇ·ñ´æÔÚ
rpm -qa|grep -i  xxxx  // ²é¿´ÏµÍ³ÖÐÊÇ·ñÒѾ­°²×°ÁËijÈí¼þµÄÏà¹ØÈí¼þ°ü
rpm -e --nodeps xxxx // Ð¶ÔØÈí ......

ʹÓÃhibernateÓëmysqlʱÊý¾Ý²»ÄܲåÈëµÄÔ­Òò¼°½â¾ö°ì·¨

1.±³¾°     
      Ö®Ç°´ÓûÓùýhibernate£¬Òò´ËÔÚÍøÉÏËÑÁËÒ»ÏÂhibernate¿ìËÙÈëÃÅ·½ÃæµÄÐÅÏ¢£¬×îºóÎÒ°´ÕÕ¡¶Myeclipse Hibernate ¿ìËÙÈëÃÅ ÖÐÎİ桷£¨CSDN£¬°Ù¶ÈÎĿⶼÓУ©Ò»ÎÄ¿ªÊ¼ÁËÎÒµÄhibernateÖ®Âã¨ÎªÏîÄ¿×ö¼¼Êõ×¼±¸£©¡£
      ÏÂÃ ......

mysql Óï¾äÓÅ»¯²éѯ

ÎÒÓõÄÊÇmysql5.0£¬
ÎÒ³ÌÐòÖÐÓõ½ÁËÒ»¾äsqlÊÇ
SQL code
select count(DISTINCT id) from Policyinfo p where p.filename not in
(select p2.filename from Policyreadinfo p2 where p2.reader='test')
µ«ÊÇÿ´ÎÔÚ³ÌÐòÖÐÿ´ÎÖ´ÐÐÕâ¾äsqlÊ±ÍøÒ³¾ÍÌØÂý£¬Òª10¶àÃ룬¶øÕâ2¸ö±íµÄ¼Ç¼ÐÐÊýÒ²¾Í1000¶à¶øÒÑ£¬ÎÒ°ÑÕâ¾äsqlµ¥¶ÀÄ ......

MysqlÖ®EXPLAINÏÔʾusing filesort

EXPLAIN ÊÇmysql½âÊÍselect²éѯµÄÒ»¸ö¹Ø¼ü×Ö,¿ÉÒԺܷ½±ãµÄÓÃÓÚµ÷ÊÔ
Óï·¨¸ñʽÈçÏÂ
EXPLAIN tbl_name
»òÕß:
EXPLAIN SELECT select_options
EXPLAIN Óï¾ä¿ÉÒÔ±»µ±×÷ DESCRIBE µÄͬÒå´ÊÀ´Óã¬Ò²¿ÉÒÔÓÃÀ´»ñȡһ¸öMySQLÒªÖ´ÐÐµÄ SELECT Óï¾äµÄÏà¹ØÐÅÏ¢¡£
EXPLAIN tbl_name Óï·¨ºÍ DESCRIBE tbl_name »ò SHOW COLUMNS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ