¶àÏß³Ì 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×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵģ¬¶ÔC ......
ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
Ö±½ÓÉÏ´úÂë°É VB code: Option Explicit Private Sub Command1_Click() Dim MyComm As New ADODB.Command Dim Rs_GetList As New ADODB.Recordset With MyComm .ActiveConn ......
ÓÐÕâôһ×éÊý¾Ý AA00000,AA00001,AA00002......AA99999 BB00000,BB00001,BB00002......BB99999 CC00000,CC00001,CC00002......CC99999 . . . . ZZ00000,ZZ00001,ZZ00002......ZZ99999
......
ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð» ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿ ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öʲôÄØ ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......