¼Ç¼MYSQLµÄÊý¾ÝÐÞ¸Ä
ÇëÎÊ¿ÉÒÔÀ¹½ØMYSQLµÄÊý¾ÝÐ޸IJ»£¿ ÎÒÏÖÔÚÓÐÒ»¸öPHP+MYSQLϵͳ ÎÒÏÖÔÚÏë¿´¿´Ìí¼ÓÒ»¸ö»áÔ±»á¶ÔmysqlÊý¾Ý±í½øÐÐÄÄЩÐ޸Ļò²åÈë ÇëÎÊÎÒ¿ÉÒÔÔÚÌí¼Ó»áÔ±µÄʱºò mysql¼Ç¼Ï¶ÔÄÄЩ±í½øÐÐÁËÐ޸ĻòÕß²åÈë²»£¿ ·ÖÎöPHPÔ´ÎļþºÜÂé·³ ÓÐЩ»¹zend¼ÓÁËÃܵÄ55
´ò¿ªÈÕÖ¾¼´¿É¼Ç¼SQLÓï¾ä [mysqld] log=123.log ÎÒÔÚ[mysql]ÏÂÃæ¼ÓÁËÕâ¸ö£º #LOG log=mylog.log È»ºóÖØÆôÁËmysql show variables like 'log'; È»¶ølog»¹ÊÇOFF ÊDz»ÊÇÄÄÀïû¿ªÆô³É¹¦£¿ ÄãµÄmysql °æ±¾ÊǶàÉÙ£¿ÒýÓà ÎÒÔÚ[mysql]ÏÂÃæ¼ÓÁËÕâ¸ö£º #LOG log=mylog.log È»ºóÖØÆôÁËmysql show variables like 'log'; È»¶ølog»¹ÊÇOFF ÊDz»ÊÇÄÄÀïû¿ªÆô³É¹¦£¿ select version() select version(); 5.0.22-community-nt; »¹ÓÐÔÙÈõÈõµÄÎÊÏ Ôõô¸´ÖÆcmdÀïµÄÄÚÈÝ£¿ OKÁË ÔÀ´ÎÒ·Å´íÁË Òª·ÅÔÚmysqldÏÂ..55 ÈçºÎ²é¿´ÈÕ־Ĩ£¿±ÈÈç²é¿´ÎÒµÄmylog.log ÎÒÔõôÔÚwinÉÏËÑË÷²»µ½Õâ¸öÎļþ£¿ ÔÚÄãµÄdatadir Ŀ¼ÖÐ ¼Ç¼±¾´ò¿ª ¹þ¹þ ÓÐÓÃÁË Ð»Ð»acmain_chm ллWWWWA лл´ó¼Ò ºÇºÇ£¬À´ÍíÁË
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: You can't specify target table 'a_table' for update in from clause ÍêÕûSQLÓï¾äÊÇ UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
echo %~dp0 CD %~dp0 mysqld.exe --defaults-file=..\my.ini --console pause ´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£ ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£ echo %~dp0 ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû CD %~dp0 ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......