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

sqlite ʹÓÃ

ÎÒÀÏÆŹ¤×÷Òª¹ÜÀíºÃ¶àµÄexcel±í¸ñ±È½ÏµÄÂé·³£¬ÓÚÊÇÏë×Å°ïæд¸öÈí¼þÈÃËý·½±ãµã
ÆäʵÎÒwinformÈí¼þ»¹Ã»ÓÐд¹ýÄØ£¬ÒÔǰдµÄ¶¼ÊÇwebµÄ
ÒòΪдµÄÈí¼þ¾ÍÊÇËý×Ô¼ºÓÃÓÃÎÒÏëÓ¦¸Ã²»ÐèÒªÓÃʲô´óµÄÊý¾Ý¿âµÄ£¬ËùÒÔÎÒ×îÏÈÏëµ½ÓÃaccessÊý¾Ý¿âͦ·½±ãµÄÎļþ¸´ÖƾͿÉÒÔÁË
¿ÉÊÇÎÒûÓÐoffice access°¡£¬²»¹ýÎҼǵõçÄÔÉϺÃÏñÓÐaccessÊý¾Ý¿âÎļþµÄ£¬ËùÓÐÕÒµ½Õâ¸öÎļþ¿ªÊ¼É¾³ý±í¸ñ£¬½¨ÐèÒªµÄ±í¸ñ
Ïë×Å·½±ãµã¾Íд¹ý¿ÉÒÔÖ´ÐÐsqlµÄ´°¿Ú£¬ÖØÀ´Ã»ÓÐд¹ý»¹ÊÇÓеãÂé·³µÄ£¬Ð´Á˸ö²Ù×÷Êý¾Ý¿âµÄÀ࣬дÍêÕâЩÎÒÒѾ­»¨ÁËÎÒÁ½¸öСʱʱ£¬ÎÒ»¹ÏëÏëÐèÒª½¨Á¢µÄ±í¸ñʲôµÄ¡£¾ÍÐÝÏ¢ÁË
ÐÝϢʱÎÒͻȻÏëµ½Óиö¿ªÔ´µÄsqliteÊý¾Ý¿â£¬ÎªÊ²Ã´²»ÓÃÕâ¸öÊý¾Ý¿âÄØ£¬ÓÃÄÇaccess¸ÉÂï°¡£¬»¹Âé·³ÄØ
µÚ¶þÌìÎÒÏÂÔØÁËÒ»¸ösqliteµÄ£¬¸ÕÏÂÔØÁËÔÚ¡£netϲ»ÄÜÓ㬺óÀ´·¢ÏÖ»¹Óиö¡£net°æµÄ
ÏÂÔصØÖ·ÈçÏ  http://sqlite.phxsoftware.com/
ÏÂÔص½Õâ¸ö¾Í¿ÉÒÔÖ±½ÓʹÓÃÁ˲Ù×÷Êý¾Ý¿â¸úÆäËüÊý¾Ý¿âÊÇÒ»ÑùµÄºÜ·½±ã°¡
½ñÌìÎÒ²Ù×÷Êý¾Ý¿âÊÇÓöµ½Á˵ÚÒ»¸öÎÊÌâÊÇ£¬²éѯÏÔʾÊÇÁ¬½Ó ×Ö¶ÎÖµµÄ
ÎÒµÚÒ»Ïëµ½µÄÊÇÓüӺţ¬ÒòΪÓùáÁËsql server¡£ºóÀ´ÍøÉϲéѯÁËһϾ¹È»ÊÇÓÃÁË||Õâ¸öµÄ£¬ºÜÆæ¹Ö°¡
»¹¾ÍÊÇʱ¼äÈÕÆÚÊÇÓöµ½ÎÊÌâÁË£¬²éѯÎĵµµÃµ½Ê¹Óà datetime() ±£´æµ½Êý¾Ý¿âÒ»²éѯ¾¹È»ÊǸúÎÒµÄʱ¼ä²î¸ö°ËСʱµÄ£¬ÓôÃÆ¡£ÒÔÇ°ÎÒдphpµÄʱºòÒ²Óöµ½¹ýÕâÑùµÄÎÊÌ⣬Ӧ¸ÃÊÇÉèÖÃʱÇøµÄÎÊÌ⣬²éѯһÏÂsqliteÊý¾Ý¿âÊÇ·ñÓÐÉèÖÃʱÇøµÄºÃÏñûµÄ£¬±£´æÊý¾Ý¿âʱÓà datetime('now','localtime') ÕâÑù¾ÍÕý³£ÁË
±£´æÈÕÆÚʱºóÀ´ÓÖÓöµ½ÎÊÌâÁË£¬ÒÔΪÎÒÖ±½Ó´Ó¡£netµÄÈÕÆÚת»¯Îª×Ö·û´®±£´æÊÇûÓÐÎÊÌâͦºÃµÄ¿ÉÊÇÎÒÒ»²éѯ¾Í³öÎÊÌâÁË
ºóÀ´ÔÚ http://www.xueit.com/html/2009-02/21_644_00.html ÕÒµ½ÎÊÌâÁË
¿´À´»¹ÓкöàҪѧϰ°¡


Ïà¹ØÎĵµ£º

SQLite3 C/C++ ¿ª·¢½Ó¿Ú¼ò½é£¨APIº¯Êý£©


SQLite3ÊÇSQLiteÒ»¸öȫеİ汾,ËüËäÈ»ÊÇÔÚSQLite 2.8.13µÄ´úÂë»ù´¡Ö®ÉÏ¿ª·¢µÄ,µ«ÊÇʹÓÃÁ˺Í֮ǰµÄ°æ±¾²»¼æÈݵÄÊý¾Ý¿â¸ñʽºÍAPI. SQLite3ÊÇΪÁËÂú×ãÒÔϵÄÐèÇó¶ø¿ª·¢µÄ:
Ö§³ÖUTF-16±àÂë.
Óû§×Ô¶¨ÒåµÄÎı¾ÅÅÐò·½·¨.
¿ÉÒÔ¶ÔBLOBs×ֶν¨Á¢Ë÷Òý.
Òò´ËΪÁËÖ§³ÖÕâЩÌØÐÔÎҸıäÁËÊý¾Ý¿âµÄ¸ñʽ,½¨Á¢ÁËÒ»¸öÓë֮ǰ°æ±¾²»¼æÈݵ ......

×ܽáSQLite²»Ö§³ÖµÄSQLÓï·¨ÓÐÄÄЩ


1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾­³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄÇ°Ê®Ìõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0Ìõ¼Ç¼¿ªÊ¼£¬Íùºó ......

SQLite FAQÖÐÎÄ°æ

1) ÈçºÎ´´½¨×ÔÔö×ֶΣ¿

¼òµ¥µÄ»Ø´ð£ºÒ»¸öÉùÃ÷Ϊ INTEGER PRIMARY KEY µÄ×ֶν«×Ô¶¯Ôö¼Ó¡£
ÕâÀïÊÇÏêϸµÄ´ð°¸£º ´Ó SQLite µÄ 2.3.4 °æ±¾¿ªÊ¼£¬Èç¹ûÄ㽫һ¸ö±íÖеÄÒ»¸ö×Ö¶ÎÉùÃ÷Ϊ INTEGER PRIMARY
KEY£¬ÄÇôÎÞÂÛÄãºÎʱÏò¸Ã±íµÄ¸Ã×ֶβåÈëÒ»¸ö NULL Öµ£¬Õâ¸ö NULL Öµ½«×Ô¶¯±»¸ü»»Îª±È±íÖиÃ×Ö¶ÎËùÓÐÐеÄ×î´óÖµ´ó
......

windowsÏÂsqlite°²×°Ê¹ÓúÍÐÔÄÜÓÅ»¯¼°ÉèÖÃ

Ô­ÎÄÁ´½Ó£ºhttp://edu.codepub.com/2008/1231/805.php
windowsÏÂsqlite°²×°Ê¹ÓúÍÐÔÄÜÓÅ»¯¼°ÉèÖÃ
      sqliteÊÇǶÈëʽSQLÊý¾Ý¿âÒýÇæSQLite£¨SQLite Embeddable SQL Database Engine£©µÄÒ»¸öÀ©Õ¹¡£SQLiteÊÇÒ»¸öʵÏÖǶÈëʽSQLÊý¾Ý¿âÒýÇæСÐÍCÓïÑԿ⣨C library£©£¬ÊµÏÖÁ˶ÀÁ¢µÄ£¬¿ÉǶÈëµÄ£¬ÁãÅäÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ