RT¡£¡£
´ó¼ÒÊÇÔõôÀ´ËãµÄ£¬½éÉܽéÉÜ·½·¨£¬²»Ê¤¸Ð¼¤£¡
¸÷λ´óÅ£ÃÇ£¬Ìû×ÓûÈ˻ذ¡£¬×Ô¼º¶¥Ò»Ï£¡
Õâ¸öÎÊÌâ±È½ÏУ¬ÎÒÊÇÖØÀ´Ã»¹À¹ý¡£
ÐèÒª¿¼ÂǵÄÒòËØ
CPUËÙ¶È£¬Äڴ棬´ÅÅÌËٶȵÈÓ²¼þÌõ¼þ¡£
²Ù×÷ϵͳÖеĽø³ÌÊýÁ¿
ÒÔÉÏΪ·þÎñÆ÷µÄ²ÎÊý¡£
È»ºóÊÇMYSQL×ÔÉíµÄÊý¾ÝÁ¿£¬
´ÓÀ´Ã»ÓйÀ¹ý£¬d ......
ÔËÐл·¾³£º redhat£º 4
gcc£º 3.4
mysql£º 5.1
#include <stdio.h>
#include "/usr/include/mysql/mysql.h"
MYSQL_RES* res_ptr;
MYSQL_ROW sqlrow;
......
¹ý³Ì£ºÉèÖô¥·¢´ÎÊý£¬Ð޸ıíflagtableÖеÄkflagΪ5¡£Ïò±ítablename2дÈëÊý¾Ý£¬µ±ËüµÄfidΪ5µÄ±¶Êýʱ£¬½«fid±£´æÏÂÀ´Ð´Èëµ½tablename1±íÖÐ
ÏÖÔÚÎÊÌâÊÇ£ºÎÒÏëдһ¸öʱ¼ä´¥·¢Æ÷£¬²»ÓÃÕâ¸ö£¬ÇëÎÊʼþ´¥·¢Æ÷Ôõôд£¬¶¨Ê±ÔÚijһʱ¿Ì¡®13£º00£º00¡¯´¥·¢£¬ÇëÎÊÕâ¸ö´¥·¢Æ÷¸ÃÔõôд£¿ Çë´ó¼Ò°ï°ï棿
SQL code:
......
±í UserTable
uName NodeID(À¸Ä¿) Time
admin 180 2008-4-4
admin 100 2008-4-6
admin 100 2008-5-5
admin 187 2008-5-21
admin&nbs ......
ÏÖÔÚÎÒÓбí1£¬±í2£¬±í3
±í1 ×ֶΣºID£¬Name£¬Price£¬aa
±í2 ×ֶΣºID£¬Name£¬Price£¬bb
±í3 ×ֶΣºID£¬Name£¬cc£¬dd¡£
ÎÒÏÖÔÚÒª²è´º±í3µÄËùÓÐ×ֶμÓÉϱí1¡¢±í2ÖеÄPrice ¼´ ID£¬Name£¬cc£¬dd£¬Price£¬±í1ºÍ±í2µ±ÖеÄPrice¶¼ÏÔʾÔÚÕâPriceµ±ÖС£
Çë½Ì´óϺ£¬ÔÚÏߵȡ ......
ÎҵķþÎñÆ÷²Ù×÷ϵͳÊÇwindows2003µÄ£¬·¢ÏÖû¸ôÒ»ÍíÉÏ£¬µÚ¶þÌìÎÒ¾ÍÎÞ·¨µÇ¼£¬»á±¨ÏÂÃæµÄ´íÎó¡£ÎÒ°´ÍøÉÏ˵µÄ£¬½«mysqlµÄwait_timeout ºÍinteractive_timeou¶¼ÉèÖóÉÁË80Сʱ£¬µ«ÊÇ»¹ÊDz»Æð×÷Ó㬸ôÒ»ÍíÉϺóÈÔÈ»»á±¨ÏÂÃæµÄ´íÎó¡£Ó¦¸ÃÔõô½â¾ö£¿»¹ÓÐΪʲôÕâЩ´íÎ󶼼ǼÔÚtomcat logÎļþ¼ÐÀïµÄǰһÌìµÄÈÕÖ¾ÀïÃæ£¬Ã»Óд´½¨½ñÌìµ ......