Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

sqliteÖ®Database is lockedÎÊÌâ

»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
 database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨ÍêÕû°²×°µÄQNX6.3.2ÉÏ£¬Ã»ÓÐÎÊÌ⣬µ«ÊÇÔËÐл·¾³ÊDzüô¹ýµÄ£¬¾ßÌå²Ã¼ôÄÚÈݲ»Ïê¡£
¶àл£¡£¡ ¿à˼ÊýÈÕ£¬ÎÞ¿ÉÄκ ......

¡¾ÈçºÎ²é¿´SqliteÊý¾Ý¿âÖÐÓжàÉÙÕűí[¶¥ÕßÓзÖ]

SqlServerÖÐÕâÑùͳ¼Æ:

select name from sysobjects where xtype='U'
ÒªÖªµÀ×ÜÊýµÄ»°¾Í¼òµ¥ÁË£º
select count(*) from sysobjects where xtype='U'

OracleÖÐÕâÑù²éѯ£º
Select * from user_tables;

========================ÒÔÉÏÁ½¸ö¶¼ÎÞ·¨Ê¹Óᣡ£================
select ......

sqlite¿ØÖÆÊý¾Ý¿â´óС

sqliteÖÐÓÐûÓжÔÓÚÊý¾Ý¿â´óС½øÐйÜÀíµÄ½Ó¿Ú£¿±ÈÈ磬´´½¨Êý¾Ý¿âµÄʱºòÖ¸¶¨Êý¾Ý¿â´óС£¬¶ÔÊý¾Ý¿â½øÐвÙ×÷ºó²ì¿´¸ÃÊý¾Ý¿âÊ£ÓàµÄ¿ÉʹÓõĿռä´óСµÈ¡£×î½ü¿´ÁËÒ»ÏÂsqliteµÄÏà¹Ø½Ó¿Ú£¬ÍøÉÏÒ²ËÑË÷ÁËÏ£¬Ã»ÓÐÕÒµ½ÓÐÓõÄ×ÊÁÏ¡£Çë¸ßÊִͽ̰¢{{ ......

sqlite ¸ßÊÖ½øÀ´°¡

СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ Ë­À´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôԭÒò °¡ Óà c ȥʵÏÖµÄ
ÄãÓõÄʲô¹¤¾ß°¡?
°ÑÄã×Ô¼ºµÄ´úÂë·¢À´¿´Ò»¿´ÏÈ
......

Sqlite intת»»ÎªÊ®Áù½øÖÆ

sqlliteÀïÃæÓÐʲô·½·¨°Ñintת»»ÎªÊ®Áù½øÖÆ´æ´¢µÄÄØ?
ÀýÈç,strftime('%s', 'now') µÃµ½1263777947,µ±Ç°µÄÃëÊý,ÎÒÏë´æ´¢ÎªËüµÄÊ®Áù½øÖƱíʾ"4B53B89B"
лл..

ÆäʵÎÒÊÇÏëstrftime('%s', 'now')²îÉúµÄÃëÊýºÍrandomblob²úÉúÒ»¸öËæ»úÊý×éºÏ×÷ΪID,ÓÃÊ®Áù½øÖÆÀ´±£´æÊÇΪÁË½Ú ......

Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ

ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃ棬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆðÀ´
SQLiteÊÇ·ñ¿ÉÒÔÓÃADOÁ¬½Ó
¼ÈÈ»ÒѾ­¿´µ½Á¬ACCESSµÄ£¬ÄÇôӦ¸ÃÉÔ×÷¸Ä¶¯¾Í¿ÉÒÔÁË°É¡£

Õâ¸ö¸úʹÓÃÄĸ ......
×ܼǼÊý:85; ×ÜÒ³Êý:15; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2] [3] [4] [5] 6 [7] [8] [9] [10] [11]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ