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
Ïà¹ØÎÊ´ð£º
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......