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

mysqlÉèÖÃÎÊÌâ

żµÄÍøÕ¾Õâô˵```
The page cannot be displayed
There are too many people accessing the Web site at this time.

¿Éʵ¼ÊÉÏ×î¶àÖ»ÓÐ3~4¸öÈËÔÚͬʱµÇ¼°¢
ÇëÎÊÈçºÎ½â¾ö°¢?ÒòΪż°²×°mysqlµÄʱºòËÆºõÑ¡ÔñÊǵÚÒ»Ïî```developer machine¶ø²»ÊÇsever machine...
ºóÃæÄǸöÁ¬½ÓÊýmsÖ»ÉèÖÃÁË100...
ÆäʵżҲ°´ÕÕmy-larger.ini ¸ÄÁ˼¸ÏîÊýÖµÔÚmy.iniÀï```Ò²ÖØÆôÁËmysql·þÎñ```
¿ÉÊÇÓкü¸Ïîmy_larger.iniµÄÊýֵżÔÚmy.iniÀïÕÒ²»µ½°¢ ±ÈÈçsocket; max_allowed_packet ;table_open_cache;thread_concurrency;
ÄÄλ¸æËßż```ÈçºÎ½â¾ö¹þ``` 555
The page cannot be displayed
There are too many people accessing the Web site at this time.

½ö´ÓÕâ¸öÀ´¿´£¬²»ÊÇMYSQLµÄÓû§ÏÞÖÆ£¬¶øÊÇÄãµÄWEB·þÎñ±¾ÉíµÄÏÞÖÆ¡£ »òÕßÄãµÄ²Ù×÷ϵͳµÄÏÞÖÆ£¨WINDOWSϵͳµÄLICENSEÓÐʱ»áÓÐÓû§ÏÞÖÆµÄ£©

ʲôÒâ˼?ʲô½Ðweb·þÎñ±¾ÉíµÄÏÞÖÆ? °³ÊÇiis + mysql+ php + windows xp
ż°ÑżµÄmy.ini ÌùÉÏÀ´°É``` Âé·³¿´¿´ºÃÂï`` ż±È½Ï¼±``` ²»ºÃÒâ˼``` ÏÖÔÚÕâÀïллÁË```

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for t


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿

ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿ÎÒÓõÄdate("Y-N-d H:i:s",time())²»ÐС£
SQL code:

mysql> desc t;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null ......

MySQL FunctionµÄÎÊÌâ

ÎÒµÄÎÊÌâÊÇÕâÑùµÄ£º

ÔÚÊý¾Ý¿âÖÐÓÐÁ½ÕÅ±í£ºtable A,table B,
table A ÖÐÓÐ×Ö¶Î_ID,channelID,_createdBy,_status
table B ÖÐÓÐ×Ö¶Î_ID,userName,_status

AÖеÄ_createdByÊÇBÖÐ_ID,BÖеÄ_IDºÍuser ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ