Îʸömysql¶à±í²éѯµÄÅÅÐòÎÊÌâ
Óï¾äÊÇÕâÑùµÄ
SELECT jingbiao_yb1,zhaobiaoadd_id,zhaobiaoadd_title,jingbiao_time,zhaobiao_time,zhaobiao_zhuangtai from `zhaobiaoadd` left join(jingbiao) on (zhaobiaoadd.zhaobiaoadd_id=jingbiao.zhaobiao_id) where zhaobiaoadd.zhaobiaoadd_title like '%»¢È¨%' group by jingbiao.zhaobiao_id order by jingbiao.jingbiao_time desc;
µ«ÊDzé³öÀ´µÄ½á¹û²¢²»ÊÇÎÒÏëÒªµÄÅÅÐò ÏÖÔڵĽá¹ûÊÇ jingbiao ²é³öÀ´µÄ½á¹ûÒ»´ó¶ÑÖØ¸´ÎÒÓÃgroup by Ö®ºóŪ³öÀ´µÄ½á¹ûËäȻûÓÐÖØ¸´Á˵«ÊÇ ³öÀ´µÄʱ¼ä²¢²»ÊÇÎÒÏëÒªµÄÎÒÏëÒª¾º±ê±íÀïÍ·µÄʱ¼äÅÅÐòµÄ×îºóÒ»¸ö½á¹ûµ«ÊÇÏÖÔÚÊÇ
µÚÒ»¸ö½á¹û
ÄãµÄÅÅÐò×Ö¶ÎÊÇ jingbiao.jingbiao_time ,¿´¿´ÊDz»ÊǸã´íÁË~
ûÓдí
Äã²éѯtime×î´óµÄʱ¼ä ²»ÐèÒª·Ö×é°¢.
¿ÉÒÔÊÔÊÔmaxº¯Êý.
ÄãÔÚselectµÄʱºòÃ²ËÆÃ»Ö¸Ã÷ÊÇÄĸö±íÀïµÄ×Ö¶ÎŶ£¬Êý¾Ý¿âĬÈϻὫËùÓбíÀïÆ¥ÅäµÄ×ֶεÄÖµÁгöÀ´£¬×ÔÈ»¾Í»áÓÐÖØ¸´ÁË£¬ÒªÏëÅÅÐò»¹µÃ¼Ó¸öorder by Óï¾ä£¬²»È»»¹Êǰ´·Ö×éÅÅÐòµØ
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......