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

MYSQL¼¼ÊõÎÊÌ⣬½â¾ö¼´¸¶200Ôª

ÎҵķþÎñÆ÷¹¹¼Ü£ºÁ½Ì¨¶ÀÁ¢·þÎñÆ÷£¬Ò»Ì¨ÓÃÓÚweb£¨php£©£¬Áíһ̨MYSQLÊý¾Ý¿âרÓ㬶¼ÊÇwin2003+IIS6.0£¬ÔÚͬһ¸ö¾ÖÓòÍøÄÚ£¬IPµØÖ··Ö±ðΪ£º'**.**.**.58'ºÍ'**.**.**.62'¡£


MYSQLÊý¾Ý¿â´æÔÚÒÔÏÂÁ½¸öÎÊÌ⣺


1¡¢Èç¹ûÎÒÔ¶³Ì×ÀÃæÁ¬½Óµ½Êý¾Ý¿â·þÎñÆ÷£¨3389¶Ë¿Ú£©£¬web·þÎñÆ÷¾Í»áÁ¬²»ÉÏMYSQLÊý¾Ý¿â£¬´íÎóÐÅÏ¢£ºCan't connect to MySQL server on '**.**.**.62' (10060)


2¡¢ÍøÕ¾¾­³£³öÏÖ´íÎóÐÅÏ¢£ºCan't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug


¿ÉÒÔÈ·Èϲ»ÊÇMYSQL·þÎñÆ÷×ÊÔ´ÎÊÌ⣬·þÎñÆ÷CPU¸ººÉÒ»°ãÔÚ15%×óÓÒ£¬ÄÚ´æ2GµÄ£¬Õ¼ÓÃÔÚ800M×óÓÒ¡£


Çó¸ßÊÖ°ï½â¾ö´ËÎÊÌ⣬Äܽâ¾öÕß¼´¸¶200Ôª³êÀÍ£¬A5Öн齻Ò×£¬¿É·ÅÐı£Ö¤£¨http://bbs.admin5.com/viewthread.php?tid=1394836 £©¡£


×¢£ºÇëÔÚÏß¼ÓQQ:17321454£¨²»ÔÚÏßʱÇë·¢Óʼþµ½QQÓÊÏ䣺17321454@qq.com)£¬ÓÉÄãÀ´Ö¸»Ó£¬ÎÒÀ´²Ù×÷£¬Ë¡²»ÄܸøMYSQLÕʺÅÃÜÂ룬ÎÊÌâ2±ØÐë±£Ö¤24СʱÄÚ²»³öÏÖ¡£

C:\Users\coolwind>perror 10060
Win32 error code 10060: ÓÉÓÚÁ¬½Ó·½ÔÚÒ»¶Îʱ¼äºóûÓÐÕýÈ·´ð¸´»òÁ¬½ÓµÄÖ÷»úûÓз´Ó¦£¬
Á¬½Ó³¢ÊÔʧ°Ü¡£

C:\Users\coolwind>perror 12
OS error code  12:  Not enough space
Win32 error code 12: ·ÃÎÊÂëÎÞЧ¡£



1¡¢Èç¹ûÎÒÔ¶³Ì×ÀÃæÁ¬½Óµ½Êý¾Ý¿â·þÎñÆ÷£¨3389¶Ë¿Ú£©£¬web·þÎñÆ÷¾Í»áÁ¬²»ÉÏMYSQLÊý¾Ý¿â£¬´íÎóÐÅÏ¢£ºCan't connect to MySQL server on '**.**.**.62' (1006


Ïà¹ØÎÊ´ð£º

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿

ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿



½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö

ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......

mysqlÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ