ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥
ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏÖ£¬µ±È»Ò²¿ÉÒ԰ѵݹéË㷨ת»»³ÉÑ»·¡£ ´ÓÖ÷Ö÷½áµã¿ªÊ¼ select * from xxx where parentid is null
È»ºóÖ ......
XML code:
<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">
<mx:Script>
<![CDATA[
import flash.data.SQLConnection;
import ......
¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ
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 de ......
ÓõÄÊÇsqllite3£¬ÇëÎÊÔÚlinuxÏÈÈçºÎÓÃCÓïÑÔµ¼³öÊý¾Ý¿â°¡£¿
"µ¼³öÊý¾Ý¿â"ÊÇÊÇʲô£¿
½« tab_xx ÖеÄÊý¾Ýµ¼³öµ½Îļþa.txt
sqlite> .output a.txt
sqlite> select * from tab_xx;
sqlite> .output stdout
µ«ÊÇÇëÎÊÓÃCÓïÑÔÈçºÎ²Ù×÷£¿
{{ ......
Ä¿Ç°ÔÚ¹«Ë¾µÄlinux pcÉÏÓÐÒ»¸öSQLite server, ÎÒÏëÓÃÔÚͬ¸öÇø網µ×ϵÄwin pcÈ¥Á¬½ÓSQLite serverÓÃASP進ÐвÙ×÷, ÇëÎÊÓа취°ìµ½Âð? »¹ÊÇSQLite serverÎÞ·¨Ö§³ÖÍøÂçÁ¬½Ó....ÕÒÁËÒ»¸öÏÂÎç
剛²ÅÎÒ×Ô¼º試ÁËÏÂ, µ×ÏÂÊÇÎÒµÄASP code, mydbÄ¿Ç°ÊÇÎÒ×Ô¼ºÔÚ±¾機ÉϽ¨³ö來µÄsqliteÎļþ, Òâ ......
sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)
ÓÐûÓÐÀàËƵŦÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬±ÈÈç
insert into table1 (id,name) values (null,'µÚÒ»ÐÐ');
insert into table1 (id,name) ......
×ܼǼÊý:85; ×ÜÒ³Êý:15; ÿҳ6 Ìõ;
Ê×Ò³ ÉÏÒ»Ò³ [1] [2] [3] [4] 5
[6] [7] [8] [9] [10] ÏÂÒ»Ò³ βҳ