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

¶àÏß³Ì Mysql Çó¾È

ÎÒÓÃsocket+mysql½øÐÐÍøÂç±à³Ì.
ÓÃUDP¡£
ÏÖÔÚÓÐ2¸öÎÊÌâÇë½Ì
1.ÎÒÓ¦¸ÃÏÈÁ¬½Ómysql.È»ºóÊÕµ½Ò»¸öÓû§ÏûÏ¢ºó¾Í¿ªÆôÒ»¸öÏß³Ì,¸ù¾ÝÏûÏ¢µÄÄÚÈÝ¿ÉÄÜ»áÖ´ÐвåÈë»ò²éѯ»ò¸üлòɾ³ýÆäÖÐÒ»ÖÖ²Ù×÷.
ÎÒÊÇËùÓÐÏ̶߳¼ÊÇÓÃÏÈÇ°µÄÁ¬½Ó »¹ÊÇÔÚÿ¸öÏß³ÌÖе¥¶À´´½¨Á¬½Ó½øÐвÙ×÷?
2.¶¼ËµMysqlÊǶàÏ̵߳Ä.ÎÒÏëÖªµÀÈç¹ûÎÒʹÓÃ1¸öÁ¬½Ó½øÐÐËùÓвÙ×÷ÐèҪͬ²½Âð,Èç¹ûÐèÒªÄÇôÊÇ·ñÒÔÉϲÙ×÷¶¼ÐèҪͬ²½?ͬÀíÈç¹ûʹÓÃÿ¸öÏ̶߳¼µ¥¶À´´½¨1¸öÁ¬½ÓµÄ·½Ê½ÐèҪͬ²½Âð,Èç¹ûÐèÒªÄÇôÊÇ·ñÒÔÉϲÙ×÷¶¼ÐèҪͬ²½?
Èç¹ûʹÓÃÿ¸öÏ̶߳¼µ¥¶À´´½¨1¸öÁ¬½ÓµÄ·½Ê½ Mysql»á²»»áÒòΪÁ¬½Ó¶àÁË ¶ø¾Ü¾øÁ¬½Ó?
mysql Óиömax connection ²ÎÊýÏÞÖÆÁ´½Ó

MySQL µÄÁ¬½Ó¸ÅÄî·Ç³£¼òµ¥£¬ Ò»¸öÁ¬½Ó¶ÔÓ¦Ò»¸öTCP/IPÁ¬½Ó¡£

ÄÇôÇëÎÊ Èç¹û ÎÒÒѾ­Á¬½ÓÁËÒ»¸öMysql ±ÈÈçMySql AÁË.
ÏÖÔÚÎÒÔÚÏß³ÌÀïÃæ´´½¨Ò»¸öMySql B,È»ºóB=A¡£ ÔÚÓÃBÀ´Ö´ÐÐÃüÁî...
ÕâËãÊÇ Ð¿ªÒ»¸öÁ¬½ÓÂð


ÒýÓÃ
ÒýÓô´½¨Ò»¸öMySql B

ÄãµÄ´´½¨µÄ´úÂëÊÇʲô£¿

ÖîÈç MySql A;mysql_init(&A);AҲͨ¹ýÓû§Ãû£¬ÃÜÂ룬Á¬½ÓÉÏÁËÊý¾Ý¿â.
ÒÔºó ÎÒÔÙ½¨MySql B; Ö´ÐÐB=A; È»ºó¾Í¿ÉÒÔÖ±½Ó µ÷ÓÃÃüÁî²»ÐèÒªÔÙ¶ÔÓÃÓû§ÃûºÍÃÜÂëÁ¬½ÓÊý¾Ý¿â£¬¿ÉÒÔÖ±½Óµ÷ÓÃmysql_queryÖ®ÀàµÄº¯ÊýÖ´ÐÐÃüÁîÁË.ÕâËãÊÇÐÂÔöÁË1Á¬½ÓÂð

²»Ëã¡£ÓõĻ¹ÊÇͬһ¸ö¡£

Æäʵ£¬Äãµ½mysqlÖп´Ò»Ï show processlist; ¾ÍÖªµÀµ±Ç°ÓжàÉÙ¸öÁ¬½ÓÁË¡£

Ô­À´Èç´Ë лл,ÎÒ¶ÔÊý¾Ý¿â²»Á˽âºÇºÇ..
ÎÒ»¹ÏëÎÊÏÂ...
ÓкܶàÓû§·¢ÏûÏ¢¹ýÀ´...
ÎÒÔÚÊÕµ½ÏûÏ¢ºó¾Í´´½¨1¸öÏß³ÌÈ¥´¦Àí...
¾ÍÓÃ1¸öÁ¬½ÓºÃ»¹ÊÇÔÚÿ¸öÏß³ÌÖж¼µ¥¶À´´½¨Ò»¸öÁ¬½ÓºÃ? <


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵģ¬¶ÔC ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQL´æ´¢¹ý³Ìµ÷ÓòÎÊýµÄÎÊÌâ

Ö±½ÓÉÏ´úÂë°É
VB code:

Option Explicit
Private Sub Command1_Click()

Dim MyComm As New ADODB.Command
Dim Rs_GetList As New ADODB.Recordset

With MyComm
.ActiveConn ......

MYSQLÊý¾ÝµÄ¼ìË÷ЧÂÊ

ÓÐÕâôһ×éÊý¾Ý
AA00000,AA00001,AA00002......AA99999
BB00000,BB00001,BB00002......BB99999
CC00000,CC00001,CC00002......CC99999
.
.
.
.
ZZ00000,ZZ00001,ZZ00002......ZZ99999
......

Çë½ÌÒ»¸ömysql triggerµÄÎÊÌâ

ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð»
ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿

ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öʲôÄØ


ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ