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 *db;
sqlite3_stmt *stat;
char
*zErrMsg = 0;
char
temp[256], FileRoot[256];
char
buffer2[1024]="0";
sprintf(temp, _T("%s"), _T("utf.db")) ......
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Ìõ¼Ç¼¿ªÊ¼£¬Íùºó ......
1¡¢SQLite¼ò½é
¡¡¡¡SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ9¸öÄêÍ·ÁË. SQLiteÒ²ÓÀ´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈëʽµÄ£¬¶øÇÒÄ¿Ç°ÒѾÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ÉÄÜÖ»ÐèÒª¼¸°ÙKµ ......
±¾ÆªÎÄÕÂÀ´Ô´ÓÚ£º¿ª·¢Ñ§Ôº http://edu.codepub.com ÔÎÄÁ´½Ó£ºhttp://edu.codepub.com/2009/0825/14358.php
SQLiteÊǸöµäÐ͵ÄǶÈëʽDBMS£¬ËüÓкܶàÓŵ㣬ËüÊÇÇáÁ¿¼¶µÄ£¬ÔÚ±àÒëÖ®ºóºÜС£¬ÆäÖÐÒ»¸öÔÒò¾ÍÊÇÔÚ²éѯÓÅ»¯·½Ãæ±È½Ï¼òµ¥£¬ËüÖ»ÊÇÔËÓÃË÷Òý»úÖÆÀ´½øÐÐÓÅ»¯µÄ£¬¾¹ý¶ÔSQLiteµÄ²éѯÓÅ»¯µÄ·ÖÎöÒÔ¼°¶ÔÔ´´úÂëµÄ ......
±³¾°
µ±Ç°Òƶ¯É豸¿ª·¢ÁìÓò£¬ÔÚ±¾µØÊý¾Ý´æ´¢·½Ã棬Sqlite¼¸ºõ³ÉÁËÊÂʵ±ê×¼£¬Andriod (android.database.sqlite)£¬iPhone (SQLite for iPhone SDK ºÍ FMDB for iPhone)£¬Palm WebOS (webOS SQL Tutorial)£¬Ð°汾µÄSymbianÒ²Ö±½Óbuilt-in SqliteÁË(20 million Symbian smartphones shipped in Q3 2007 Newer versions of th ......