mysqlµÄÐ¶ÔØÎÊÌ⣡
×î½üÔÚѧϰtomcat+mysql¿ª·¢web£¬ÔÚ°²×°ºÍÐ¶ÔØmysqlµÄ¹ý³ÌÖÐÓöµ½ÁËһЩÎÊÌ⣬ÕÛÌÚÁËÎҺü¸Ìì¡£ÔÚÕâÀï¸ø´ó¼Ò½ÌÒ»ÏÂÍêÕûµÄÐ¶ÔØmysqlµÄ¹ý³Ì¡£
ÓÐʱºò֮ǰ°²×°¹ýmysqlÐ¶ÔØºóÓÖÖØÐ°²×°µÄ¹ý³ÌÖУ¬°²×°ºÃµÄmysql½ø²»È¥£¬ÈÃÈ˾õµÃºÜÐÄ·³£¬×Ô¼ºÒÑ¾Ð¶ÔØÁË£¬ÖØÐÂ×°Á˺óΪʲô½ø²»È¥ÄØ¡·£¿£¿ ÔÒòÊÇÐ¶ÔØ¹ý³Ì²¢²»ÍêÕû¡£ÎҰѹý³ÌÖзÖΪÒÔϼ¸¸ö¹ý³Ì¡£
1£ºµ½¿ØÖÆÃæ°å———Ìí¼Ó»òɾ³ý³ÌÐòÀïÕÒµ½mysqlÑ¡ÔñÐ¶ÔØ£»
2£º°ÑÕâ¸öÎļþҲɾ³ýÁËX:\Program Files\MySQL£¬¾ÍÊǰÑÕâ¸öĿ¼Ҳɾ³ýÁË£»
3£ºÏÂÃæÒ²¾ÍÊÇ×îÖØÒªµÄÒ»µã£¬Ò²ÊÇÈúܶàÈËÀ§»óµÄÒ»µã¡£ÆäʵmysqlµÄ°²×°¹ý³ÌÖÐÒѾÔÚÕâ¸öĿ¼ĬÈÏÁËÒ»¸ömysqlÎļþ£»
ÔÚX:\Documents and Settings\All Users\Application DataÔÚÕâ¸öĿ¼Ï»¹ÓÐÒ»¸ömysqlÎļþ£¬°ÑÕâҲɾ³ýÁË£¬Õâ¾ÍÍêÃÀÐ¶ÔØÁË¡£
½ÓÏÂÀ´Äã¾ÍÄÜÖØÐ°²×°ÄãµÄmysqlÁË£¬È»ºó½øÐÐÅäÖá£
ºÙºÙ£¬×£ÄãÃdzɹ¦¡£ ÎÒÊǸö´ó²ËÄñ£¬Ï£ÍûÄܰïÖúµ½Ò»Ð©ºÍÎÒÒ»ÑùµÄ²ËÄñ£¬ÉÙ×ßÍä·£¬ÎÒ×ßÁË£¬Äã¾Í²»ÒªÁË£¡£¡
Ïà¹ØÎĵµ£º
Ð¶ÔØMySQLÊý¾Ý¿â£º
ÏÈÍ£µôWINDOWSÀïµÄMySQL·þÎñ£»
ÓÃ360°²È«ÎÀʿǿÐÐɾ³ýMySQLÊý¾Ý¿â
½Ó×ÅÔÚ×¢²á±íÀïÇå³ýMySQL·þÎñ£º
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
3¡¢HKEY_ ......
MySQLÈÕÆÚ×ֶηÖDateºÍTimeÁ½ÖÖ£¬oracleÈÕÆÚ×Ö¶ÎÖ»ÓÐDate£¬°üº¬ÄêÔÂÈÕʱ·ÖÃëÐÅÏ¢£¬Óõ±Ç°Êý¾Ý¿âµÄϵͳʱ¼äΪsysdate,¾«È·µ½Ã룬»òÕßÓÃ×Ö·û´®×ª»»ÈÕÆÚÐͺ¯Êý£º
To_date('2001-08-01','YYYY-MM-DD'); Äê-ÔÂ-ÈÕ
24Сʱ£º·ÖÖÓ£ºÃëµÄ¸ñʽ 'YYYY-MM-DD HH24:MI:SS'  ......
MySQLÖеÄÁ÷³Ìº¯Êý
º¯Êý
¹¦ÄÜ
IF(value,t ,f)
Èç¹ûvalueÎªÕæ£¬·µ»Øt£¬·ñÔò·µ»Øf
IFNULL(value1,value2)
Èç¹ûvalue1²»Îª¿Õ·µ»Øvalue1,·ñÔò·µ»Øvalue2
CASE WHEN [value1] THEN [result1] … ELSE [default] END
Èç¹ûvalue1ÎªÕæ ·µ»Øresult2 ·ñÔò·µ»Ødefault
CASE [expr] WHEN [value1] THEN [result1] &helli ......
×î½üÒ»Ö±ÔÚÑо¿freeBSDÏÂnginx+php+mysqlµÄ°²×°£¬¿´Á˺ܶàÍøÉϵÄ×ÊÁÏÊÕ»ñ²»Ð¡£¬²»¹ý´ó²¿·Ö¶¼ÊDZàÒë°²×°£¬Ïà¶Ô³õѧÕßÀ´Ëµ±È½Ï¸´ÔÓ£¬²»ÈÝÒ×Àí½â£¬ËùÒÔÎÒÕûºÏÁËһЩports°²×°µÄ×ÊÁÏ£¬¶¼ÊǾ¹ý×Ô¼ºÑéÖ¤ºóµÄ£¬°²×°³É¹¦Ò²±È½ÏÈÝÒ×Àí½â£¬ÏÂÃæÊÇÁ½Öֳɹ¦µÄ°¸Àý£¬ÆäÖÐÓÐÒ»¸öÊÇApache´úÌænginxµÄ°²×°£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
° ......
ÒÔÏÂΪOracleºÍMySQLÊý¾Ý¿âµÄһЩ¼òµ¥ÃüÁî¶Ô±È£¬¿´¿´ËüÃÇÖ®¼ä´æÔÚÄÄЩ²îÒì
¡¡¡¡SQL> select to_char(sysdate,'yyyy-mm-dd') from dual;
¡¡¡¡SQL> select to_char(sysdate,'hh24-mi-ss') from dual;
¡¡¡¡mysql> select date_format(now(),'%Y-%m-%d');
¡¡¡¡mysql> select time_format(now(),'%H-%i-%S');
¡¡¡¡ÈÕÆÚº ......