¹ØÓÚMySQLµÄ²éѯ½á¹û
´úÂëÈçÏ£º
$sql = "select count(*) from admin";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
echo $num;
Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬
ÎÒÏëÊä³ö²éѯµÄ½á¹û£¬Ó¦¸ÃÔõôÐ޸ģ¿
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁË°É¡£
¸Õѧmysql,ÕÕ×ÅÊ ......
ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦± ......
ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æΪ4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
ÓÐûÓиßÈË°ïæÅäÖÃÒ»ÏÂmy.cnf
Õâ¸öûÓж¨Â۵ģ¬¾ßÌå ......
Êý¾Ý¿âÒýÇæʹÓÃMYISAM
ÀýÈç±íÃû£ºLOG¡¡Ã¿Ìì»á²úÉú400Íò×óÓҵļǼ
ÈÕ»ýÔÂÀÛÊý¾ÝÁ¿»á·Ç³£Ö®³è´ó
ËùÒÔ¿¼Âǵ½Õâµã
ÎÒÏëÁËÁ½¸ö·½°¸
1¡¢Ã¿Ìì²úÉúÒ»¸ö±í£¬ÀàËÆLOG20091010¡¢LOG20091011
2¡¢Ã¿Ìì ......