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

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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

mysql ÀÛ¼ÓÔËËã - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

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·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ