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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......