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
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......