Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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

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

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

ÏÂÃæÀý×ÓÖÐÓÐÒ»¸öÆäËüÊý¾Ý¿âÖеÄËã·¨£¬»òÐí¿ÉÒԲο¼Ò»ÏÂ

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/02/4142971.aspx
MySQLÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ


лл°¡ ÎÒÑо¿Ò»Ï ²»¶®ÔÙÎÊ

×îºóʹÓÃÁ˾²Ì¬·½·¨½¨Á¢ÁËÊ÷×´½á¹¹
ºÇºÇ
ÎÄÕÂÊÕ²ØÁË ÒÔºóÓ¦¸Ã»¹ÓÐÓõõ½µÄµØ·½
лл
ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏÖ£¬µ±È»Ò²¿ÉÒ԰ѵݹéË㷨ת»»³ÉÑ­»·¡£ ´ÓÖ÷Ö÷½áµã¿ªÊ¼ select * from xxx where parentid is null
È»ºóÖð¸öÏÔʾ¡£

ÏÂÃæÀý×ÓÖÐÓÐÒ»¸öÆäËüÊý¾Ý¿âÖеÄËã·¨£¬»òÐí¿ÉÒԲο¼Ò»ÏÂ

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/02/4142971.aspx
MySQLÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ



Ïà¹ØÎÊ´ð£º

SQliteµÄÒ»¸öÎÊÌâ

ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '200 ......

sqlite£¬updateµÄÎÊÌâ

ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£

ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵģ¬µ«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º

ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£

ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......

ÓùýsqliteµÄÅóÓÑ¿´ÏÂ

×î¼òµ¥µÄÎÊÌâ¡£Ò²ÓеãÓôÃÆ¡£
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â
ÎÒÏÖÔÚÖ»ÓÐÒ»¸ösqlite3.exeÎļþ¡£
ÎÒʹÓõķ½·¨ÊÇË«»÷Õâ¸öÎļþ
ʹÓõÄÃüÁîΪ£º
sqlite3 f:\a.db »Ø³µ
¿ÉÊǽá¹ûÈ´ÏÔʾΪ
  ...>
sqli ......

sqliteÖ®Database is lockedÎÊÌâ

»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
 database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨Íê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ