sqliteÊý¾Ý¿â²éѯ±í¿¿Ç°
¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ select * from web_news order by id desc limit 0,6 web_news ±íÀïÓÐTOPÁÐ ÔõÑùÈÃTOPÁмǼΪ1µÄΪÖÃǰ ¸÷λ´ó´óÃǰï°ïæ ·Ö²»¶à Çë°üº£¡£¡
order by top²»ÐÐÂ𣿠idºÍtopÄǸöÓÅÏÈ£¿ SQL code: select * from web_news order by top!=1 ,id desc limit 0,6; ÄãµÄÒâ˼ÊDz»ÊÇtop=1µÄÊÇÖö¥µÄÄØ£¿ SELECT * from web_news ORDER BY `topid` DESC LIMIT 0 , 6 ²¹³äһϣ¡ ÄãµÄÒâ˼ÊDz»ÊÇtop=1µÄÊÇÖö¥top=0µÄ²»Öö¥µÄÄØ£¿ SELECT * from web_news ORDER BY 'top' DESC LIMIT 0 , 6 ÒýÓà SQL codeselect*from web_newsorderbytop!=1 ,iddesc limit0,6; THANK YOU ½â¾öÁË!
Ïà¹ØÎÊ´ð£º
ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file file is encrypted or is not a database¡£ ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´ S ......
ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite; ¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn; ¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË. The type 'System.Data.Common.DbConnection' is defined in an ass ......
ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£ ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆð ......
ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£ ±ÈÈ磺 Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ ÒýÓà һ°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......