ÈçºÎÈ¡µÃǰһ´Î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»Ì«¿Ï¶¨¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......