mysqlÀïÃæÊÇÔõôÊÔÓñí±äÁ¿µÄ£¿
mysqlÀïÃæÊÇÔõôÊÔÓñí±äÁ¿µÄ£¿ ¾Ù¸öÀý×Ó¡£¼°½éÉÜһϡ££¨ ¶ÔSQL Server±È½ÏÊìϤ£¬¶àMySQL²»Ì«Êì¡££© ¶àл£¡
ʲôÊÇ¡°±í±äÁ¿¡±£¿¡¡½¨Òé¾ÙÀý˵Ã÷£¬£Í£Ù£Ó£Ñ£ÌÖкܶà¸ÅÄîÓëÆäËüÊý¾Ý¿âÓÐЩ²îÒì¡£ MYSQLûÓбí±äÁ¿ ûÓбí±äÁ¿£¬Äã¿ÉÒÔʹÓÃÁÙʱ±íÀ´ÊµÏÖÕâ¸ö¡£ to WWWWA: ÄÇÎÒÃÇÔõôʵÏÖÀàËÆ±í±äÁ¿µÄ¹¦ÄÜ£¿ £¨ ²»ÏëÓÃMySQLµÄÁÙʱ±í£¬ÕâÑù´¦ÀíÍêÁË»¹ÒªÉ¾³ý£¬ÕâÑùÕʺÅÐèҪɾ³ýȨÏÞ¡£ÕâÑùµÄÕʺţ¬Î£ÏÕϵÊýÌ«¸ß£© ¶àл£¡ To yangxiao_jiang as well, ÄÇÎÒÃÇÔõôʵÏÖÀàËÆ±í±äÁ¿µÄ¹¦ÄÜ£¿ £¨ ²»ÏëÓÃMySQLµÄÁÙʱ±í£¬ÕâÑù´¦ÀíÍêÁË»¹ÒªÉ¾³ý£¬ÕâÑùÕʺÅÐèҪɾ³ýȨÏÞ¡£ÕâÑùµÄÕʺţ¬Î£ÏÕϵÊýÌ«¸ß£© ¶àл£¡ ºÇºÇ£¬Ã»Óа취£¬MYSQL²»ÊÇSQLSERVER£¬Ö»ÓÐÓÃÁÙʱ±í ²»ÐèҪɾ³ýȨÏÞ°¡¡£ create temporary table ... ÁÙʱ±í»áÔÚconnection ¶Ïµôʱ×Ô¼ºÇå³ýµÄ¡£ To wwwwb, ÄÇÓÐûÓа취£¬Óиö·½°¸¿ÉÒÔʵÏÖÀàËÆÓë±í±äÁ¿ÄØ¡£ Ϊʲôһ¶¨ÒªÓñí±äÁ¿£¬¼òҪ˵Ã÷Ò»ÏÂÒýÓà To yangxiao_jiang as well, ÄÇÎÒÃÇÔõôʵÏÖÀàËÆ±í±äÁ¿µÄ¹¦ÄÜ£¿ £¨ ²»ÏëÓÃMySQLµÄÁÙʱ±í£¬ÕâÑù´¦ÀíÍêÁË»¹ÒªÉ¾³ý£¬ÕâÑùÕʺÅÐèҪɾ³ýȨÏÞ¡£ÕâÑùµÄÕʺţ¬Î£ÏÕϵÊýÌ«¸ß£© ¶àл£¡ ÁÙʱ±í£¬ÊDz»ÐèҪɾ³ýµÄ£¬ÔÚÄã¶Ï¿ªÁ¬½ÓµÄʱºò£¬ÏµÍ³»á×Ô¶¯É¾³ýµÄ¡£
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: 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 ......