Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Sqlite

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏÖ£¬µ±È»Ò²¿ÉÒ԰ѵݹéË㷨ת»»³ÉÑ­»·¡£ ´ÓÖ÷Ö÷½áµã¿ªÊ¼ select * from xxx where parentid is null
È»ºóÖ ......

flex airÁ¬½Ósqlite²éѯ±¨´í£ºno such table

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 ......

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 de ......

sqlite3 linuxÏÂCÓïÑÔµÄÎÊÌâ

ÓõÄÊÇsqllite3£¬ÇëÎÊÔÚlinuxÏÈÈçºÎÓÃCÓïÑÔµ¼³öÊý¾Ý¿â°¡£¿
"µ¼³öÊý¾Ý¿â"ÊÇÊÇʲô£¿

½« tab_xx ÖеÄÊý¾Ýµ¼³öµ½Îļþa.txt
sqlite> .output a.txt
sqlite> select * from tab_xx;
sqlite> .output stdout


µ«ÊÇÇëÎÊÓÃCÓïÑÔÈçºÎ²Ù×÷£¿
{{ ......

SQLiteÓа취͸¹ýÍøÂçÁ¬½ÓÂð?

Ä¿Ç°ÔÚ¹«Ë¾µÄlinux pcÉÏÓÐÒ»¸öSQLite server, ÎÒÏëÓÃÔÚͬ¸öÇø網µ×ϵÄwin pcÈ¥Á¬½ÓSQLite serverÓÃASP進ÐвÙ×÷, ÇëÎÊÓа취°ìµ½Âð? »¹ÊÇSQLite serverÎÞ·¨Ö§³ÖÍøÂçÁ¬½Ó....ÕÒÁËÒ»¸öÏÂÎç


剛²ÅÎÒ×Ô¼º試ÁËÏÂ, µ×ÏÂÊÇÎÒµÄASP code, mydbÄ¿Ç°ÊÇÎÒ×Ô¼ºÔÚ±¾機ÉϽ¨³ö來µÄsqliteÎļþ, Òâ ......

sqlite ×Ö¶ÎĬÈÏÖµµÈÓÚidÖµ

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]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ