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

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²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
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 ......

°ïæ¿´¿´MySQLÓйصÄÅú´¦ÀíÎļþµÄÓï·¨

echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£

echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ