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
Ïà¹ØÎÊ´ð£º
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼ ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......