SQLITE²åÈëÓï¾ä´íÎó
SQL code:
IF NOT EXISTS(SELECT * from Company WHERE MAC='aa:22:cc:22:ee:ff')
INSERT INTO Company(Mac,CompanyId,CompanyName,FtpParameter) Values('aa:22:cc:22:ee:ff','00101','aabbcc','192.168.123.11|21|abc|abc')
ΪʲôÌáʾ£º
Error message: SQL script is wrong
SQL code:
create table #t(Mac varchar(50),CompanyId varchar(50),CompanyName varchar(50),FtpParameter varchar(50))
IF NOT EXISTS(SELECT * from #t WHERE MAC='aa:22:cc:22:ee:ff')
INSERT INTO #t(Mac,CompanyId,CompanyName,FtpParameter) Values('aa:22:cc:22:ee:ff','00101','aabbcc','192.168.123.11|21|abc|abc')
select * from #t
Mac CompanyId CompanyName FtpParameter
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- --------------------------------------------------
aa:22:cc:22:ee:ff 00101 aabbcc 192.168.123.11|21|abc|abc
(1 ÐÐÊÜÓ°Ïì)
drop ta
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¡
sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.
Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string
ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎ ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý ......