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

fleaphpÖÐsqliteÔõôÓÃ

ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿


ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇһЩСÍøÕ¾

id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÒýÓÃ
id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÎÒÖªµÀÕâÑùÄÜ×ÔÔö£¬ÎÒÏëÎʵÄÊÇfleaphp²»ÄÜÌí¼ÓÊý¾Ý£¬³öÏÖ´íÎóµÄµØ·½ºÃÏñÊÇ»ñÈ¡×î´óIDµÄʱºò£¬sqliteÖ§³Ölast_insert_idÂð

sqlite_last_insert_rowid

Ë­ÓÐÔÚfleaphp 1.7ÖÐÄÜÓõÄsqliteÇý¶¯°¡

up

ÓÃsqliteµÄÈ˾ÍÕâôÉÙÂð

ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

ÒýÓÃ
ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

Äĸö¿ò¼ÜѧϰÇúÏßƽ»ºÄØ£¿
ÎÒÕýÔÚÕÒÒ»¸ö¿ò¼Üѧѧ


Ïà¹ØÎÊ´ð£º

ÈçºÎ½«±äÁ¿ÖеÄÊý¾Ý´æ´¢µ½SQLiteÊý¾Ý¿âÖÐ

mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");

ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......

Óа취ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ²Ù×÷sqliteÊý¾Ý¿âÂð£¿

visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿Ë­Óнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

SQLITE ÏÂÃæµÄÓï¾ä¸ÃÔõôд

ÔÚ SQL SERVER ÖеÄÓï¾ä ÊÇ£º
  SELECT
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) / 4 + 1 AS TitleRow,
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) % 4 + 1 AS Title ......

ÓùýSQLiteµÄÅóÓѺÍÍæ¹ýÅú´¦ÀíµÄÅóÓѽøÀ´¿´Ò»ÏÂ.


    żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£

    @echo off
    echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ