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

ÈçºÎÈ¡µÃǰһ´ÎMySql²Ù×÷ËùÓ°ÏìµÄÐÐÊý?

mysql_affected_rows()ÊDz»ÊÇ¿ÉÒÔÈ¡µÃǰһ´Î²Ù×÷Èçselect¡¢update¡¢insert¡¢deleteËùÓ°ÏìµÄÐÐÊý°¡£¿

°ïÖúÎĵµÉÏ£º

ÃèÊö

·µ»ØÉÏ´ÎUPDATE¸ü¸ÄµÄÐÐÊý£¬ÉÏ´ÎDELETEɾ³ýµÄÐÐÊý£¬»òÉÏ´ÎINSERTÓï¾ä²åÈëµÄÐÐÊý¡£¶ÔÓÚUPDATE¡¢DELETE»òINSERTÓï¾ä£¬¿ÉÔÚmysql_query()ºóÁ¢¿Ìµ÷Ó᣶ÔÓÚSELECTÓï¾ä£¬mysql_affected_rows()µÄ¹¤×÷·½Ê½Óëmysql_num_rows()ÀàËÆ¡£



SQL code:
mysql> INSERT INTO t VALUES(1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> SELECT ROW_COUNT();
+-------------+
| ROW_COUNT() |
+-------------+
| 3 |
+-------------+
1 row in set (0.00 sec)



FOUND_ROWS() : select
ROW_COUNT()  : update delete insert.

?  ²»Ì«Ã÷°×¡£¡£¡££¨¿ÉÄÜÓëÎÒÏëÒªµÄ½á¹û°É£©
ÎÒµÄÄ¿±êÊÇ£º
£¨1£©½«¸÷ÖÖ²»Í¬µÄ²Ù×÷£¨select£¬insert£¬update£©·ÅÔÚÒ»¸ö¶ÓÁÐÖУ¬Ê¹ÓöàÏß³ÌÖ´ÐжÓÁÐÖеÄSQLÓï¾ä¡£
£¨2£©ÔÚ²»Í£Ö´ÐеÄʱºò£¬°Ñ½á¹û·ÅÈëµ½ÁíÍâÒ»¸ö¶ÓÁÐÖС£
£¨3£©¶ÁÈ¡½á¹û¶ÓÁÐÖеÄÊý¾Ý£¬Äܹ»¸ù¾Ý½á¹ûÅжÏÊý¾Ý¿â²Ù×÷ÊÇ·ñ³É¹¦¡£

mysql_affected_rows()ÄØ£¿  °ïÖúÎĵµÈçºÎÀí½â£¿

mysql_affected_rows()
Õâ¸öÊÇC APIÖеĺ¯Êý¡£Í¬ÑùÊÇÈ¡µÃ¶àÉÙÐб»¸ÕÖ´ÐеÄSQLÓï¾ä¸üÐÂ/²åÈë/ɾ³ý»òSELECT



È·¶¨¿ÉÒÔÂ𣿠 ·´ÕýÎÒÒ²ÊÇÊÔ¹ýµÄ£¬µÄÈ·ÊÇÕýÈ·µÄ½á¹û£¬¾ÍÊDz»Ì«¿Ï¶¨¡£

ÒýÓÃÈ·¶¨¿ÉÒÔÂð


Ïà¹ØÎÊ´ð£º

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

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

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

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

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ