mysql ¶à×Ö¶ÎÅÅÐòµÄÎÊÌ⣬ÔÚÏߵȡ¡
s_user ±íÖк¬id loginTime¡¡¶þ×Ö¶Î
ÏÖÏëͨ¹ý¡¡idµÄ´óµ½Ð¡£¬Í¬Ê±ÓÖÒª°´loginTimeµÄ×î½üµ½×î¾ÃͬʱÅÅÐò
ÔõôʵÏÖѽ£¬
£¨ÎÒ×Ô¼ºÐ´µÄselect id from s_user order by loginTime desc ,id desc ÔËÐв»³É¹¦¡¡£©¶àл
¿´²»³öÓÐʲôÎÊÌâ.ÄãдµÄSqlÓ¦¸ÃÊÇÕýÈ·µÄ...ÄãÔËÐдíÎóµÄÐÅÏ¢ÊÇʲô
ûÓдíÎóÐÅÏ¢£¬Ö»ÊÇÔËÐнá¹ûÖ»°´Á˵ÚÒ»¸ödescÅÅ
ÕâÌõÓï¾äûÎÊÌ⣬ÎÒÏëÄãÑ¡ÔñÊý¾Ý¿â´íÎóÁË»òÕß×Ö¶ÎÃû/±íÃûд´íÁË? Ìṩ³ö´íÐÅÏ¢
select id,loginTime from s_user order by loginTime desc ,id desc
ÁíÍâÄãÒª¿´½á¹û¡£ÄãÒª×Ô¼ºÔö¼Ó¼¸Ìõ¸ÉÈżÇ¼À´ËµÃ÷ÎÊÌâ¡£¡£
ÄãÒª×Ô¼ºÔö¼Ó¼¸Ìõ¸ÉÈżÇ¼À´ËµÃ÷ÎÊÌâ
------------
·ÖÎöµÄÓеÀÀí
PHP code:
select * from s_user order by loginTime desc ,id desc
ÎÒÔËÐÐÁËÄãµÄSQLÓï¾ä£¬Ã»Óб¨´í£¬ÎÒÏë¿ÉÄÜÊÇÄãÑ¡ÔñµÄÊý¾Ý¿â´íÎóÁË»òÕß×Ö¶ÎÃû/±íÃûд´íÁË? Ìṩ³ö´íÐÅÏ¢
zgycsmb:
Óï¾äÎÞÎÊÌ⣬ÊÇ·ñloginTime¶¼²»Í¬Ñ½£¬ÈôÈç´Ë£¬ÔòµÚ2ÅÅÐòid¿Éɾ³ý£¬idµÄÅÅÐòÖ»ÔÚloginTimeÏàͬʱÆð×÷Óá£
select id from s_user order by loginTime desc ,id desc
¶àл´ó¼Ò
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......