mysql²¢·¢·ÃÎʳö´í - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÓÃLR²âÊÔÓû§²¢·¢£¬³ÖÐø²¢·¢100¸ö£¬Öмä·ÃÎÊÍøÕ¾£¬¾Í»á³öÏÖ´íÎóCan't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)£¬²»ÖªµÀÕ¦»ØÊ£¿ÔÙµã»÷¾ÍÓÖÕý³£ÁË£¬ÊDz»²¢·¢Ì«¶àÔì³ÉmysqlµÄÆ¿¾±£¿
ÎÒÉÏÍøgoogleÁËÒ»°Ñ£¬¾ø´ó¶àÊý·´Ó¦µÄÕâ¸öÎÊÌâ¶¼ÊÇÆô¶¯Êý¾Ý¿âµÄʱºò³öÏֵġ£ÔÎÁË¡¡
½¨Òéµ½MYSQL°æ¿éÌáÎÊ
[Quote=ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´:
..]
½¨Òéµ½MYSQL°æ¿éÌáÎÊ
[/Quote]
..
лл£¬ÎÒÒѾÔÚmysql°æ¿é·¢ÌûÁË£¬ºÇºÇ
ÐÞ¸Ä my.iniÎļþ
Êý¾Ý¿âϵͳÔÊÐíµÄ×î´ó¿ÉÁ¬½ÓÊý
max_connections = ÄãÏëÒªµÄÊý¡£Èç¹û²»ÉèÖã¬Ä¬ÈÏÊÇ100¡£×î´óÊÇ16384¡£
my.ini ÔÚlinuxÏÂÔÚ /etc/ ÏÂÃæ windows ¾Í²»ÖªµÀÁË
»Ø¸´4Â¥
ÒѾ°Ñ×î´óÁ¬½ÓÊýÉèΪ1000ÁË£¬µ«ÊÇ¿ìËÙ·ÃÎÊmysql£¬»¹ÊÇ»á³öÏÖCan't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'µÄÇé¿ö£¬ÄѵÀmysql.sockÊǼ´Ê±Éú³ÉµÄÎļþÂ𣿷´¸´Ë¢Ò³Ã棬¾Í»á³öÏÖÕÒ²»µ½mysql.sock
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......