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

SqliteʵÏÖĬÈÏʱ¼äΪµ±Ç°Ê±¼äÁеķ½·¨

    ÔÚSQL ServerÖУ¬´´½¨±í¸ñµÄʱºò£¬¶ÔÓÚʱ¼äÁÐÓÐʱºòÎÒÃÇ¿ÉÒÔ¸ù¾ÝÐèÒªÖ¸¶¨Ä¬ÈÏֵΪµ±Ç°Ê±¼ä£¨Ò²¾ÍÊÇ˵¼Ç¼Éú³ÉµÄʱºòÓÐĬÈϵÄʱ¼ä´Á£©¡£ÀýÈ磺
    create table log(
content varchar(256),
logtime datetime default getdate()
)
  
    È»¶øÔÚSqliteÖÐÈçºÎʵÏÖÄØ£¿²éÎĵµµÃÖªSqliteÖв¢Ã»ÓÐgetdate()º¯Êý£¬µ«ÆäϵͳÄÚÖú¯ÊýÓÐdatetime()£¬Òò´ËÄܲ»Äܰ´ÕÕÏÂÃæµÄд·¨ÊµÏÖĬÈÏʱ¼ä´ÁÄØ£º
    create table log(
content varchar(256),
logtime datetime default datetime('now')
)
  
    ´ð°¸ÊÇ·ñ¶¨µÄ£¬»áÌáʾÓï·¨´íÎó¡£ÄÇôӦ¸ÃÈçºÎÉùÃ÷ÄØ£¿ÈçÏÂËùʾ£º
    create table log(
content varchar(256),
logtime TIMESTAMP default CURRENT_TIMESTAMP
)
    
    Õâ¸ö¿ÉÒԴﵽЧ¹û£¬µ«ÊÇĬÈϵÄʱ¼äÊÇÒÔ¸ñÁÖÄáÖαê׼ʱ¼äΪ»ù×¼µÄ£¬Òò´ËÔÚÖйúʹÓõϰ»áÕýºÃÔç8¸öСʱ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ÎÒÃÇ¿ÉÒÔÕâÑùÉùÃ÷£º
    create table log(
content varchar(256),
logtime TIMESTAMP default (datetime('now', 'localtime'))
)

    ²âÊÔһϣ¬Ò»ÇÐÕý³££º£©


Ïà¹ØÎĵµ£º

sqlite´úÂëµÄ±àд

 ÏÂÔØ´úÂë
È¡µÃÒ»·Ý¶þ½øÖÆ¿½±´, »òÕßÊÇÔ´´úÂë²¢×Ô¼º±àÒëËü. ¹ØÓÚ ÏÂÔØÒ³£¨download£© µÄ¸ü¶àÐÅÏ¢.
´´½¨Ò»¸öÐÂÊý¾Ý¿â
ÔÚ DOS ÃüÁîÐÐÏÂ, ÊäÈë: "sqlite3 test.db". ½«´´½¨Ò»¸öеÄÊý¾Ý¿âÎļþÃû½Ð"test.db". (Äã¿ÉÒÔʹÓò»Í¬µÄÃû×Ö)
ÊäÈë SQL ÃüÁîÔÚÌáʾ·ûÏ´´½¨ºÍдÈëеÄÊý¾Ý.
д³ÌÐòʹÓà SQLite
ÏÂÃæÊÇÒ»¸ö¼òµ¥µ ......

[ת]JavaÁ¬½ÓSQLite dbÊý¾Ý¿âÎļþ

JavaÁ¬½ÓSQLiteÊý¾Ý¿âÏê½â ÏÂÔØSQLiteÊý¾Ý¿âµÄJDBC ÕâÀï¸ø³öÒ»¸öÖÐÎÄÕ¾µãµÄURL: ÉèÖû·¾³±äÁ¿£º ½«ÏÂÔØµ½µÄ°ü½âѹºóµÃµ½jar°ü sqlitejdbc-v033-nested.jar ·Åµ½%JAVA_HOME%\lib Ï£¬²¢ÇÒ½«ÆäÌí¼Óµ½classpathϵͳ»·¾³±äÁ¿ÖÐ,ÎÒµÄclasspathϵͳ»·¾³±äÁ¿ÏÖÔÚΪ: .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\li ......

SQLite Tutorial in PHP

 
SQLite Tutorial in PHP
SQLite is an SQL database manager used locally or on a website, and compatible
in particularly with PHP.
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ