Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¸öÁ¬½ÓºÃ»¹ÊÇÔÚÿ¸öÏß³ÌÖж¼µ¥¶À´´½¨Ò»¸öÁ¬½ÓºÃ? <


Ïà¹ØÎÊ´ð£º

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

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

Winform+MySQL×öÏîÄ¿

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

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ