sqliteÒÆÖ²wince
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð»ÁË
ÍøÉÏÓÐwince°æ±¾£¬±ðÈ˱àÒëºÃµÄ¡£
ÕÒһϣ¬¿ÉÒÔÓõġ£ÎÒÓùý
ÎÒÔÚÖ´ÐÐ.exeÎļþºó
´´½¨¿â
sqlite>sqilte3 test.db
...>create table foo(id integer);
È»ºó¾Í±¨ÁËÏÂÃæµÄ´íÎó
Error:near "sqlite3":syntax error
ÇëÎÊÔõô½â¾öÄØ
ÔÚÍøÉÏÕÒÔ´Â룬ȻºóÓÃ×Ô¼ºµÄ»·¾³±àÒ룬¾Í¿ÉÒÔÁË
{{
Ïà¹ØÎÊ´ð£º
SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓÃ
Ìáʾ:
sqlite error
no such function: stuff
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......
×î¼òµ¥µÄÎÊÌâ¡£Ò²ÓеãÓôÃÆ¡£
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â
ÎÒÏÖÔÚÖ»ÓÐÒ»¸ösqlite3.exeÎļþ¡£
ÎÒʹÓõķ½·¨ÊÇË«»÷Õâ¸öÎļþ
ʹÓõÄÃüÁîΪ£º
sqlite3 f:\a.db »Ø³µ
¿ÉÊǽá¹ûÈ´ÏÔʾΪ
...>
sqli ......
СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ ËÀ´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôÔÒò °¡ Óà c ȥʵÏÖµÄ
ÄãÓõÄʲô¹¤¾ß°¡?
°ÑÄã×Ô¼ºµÄ´úÂë·¢ ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......