Sql

 
 

sqlite

2011年6月18日

21:33

 
 

VC中使用sqlite[转]

 
 

源文档 <http://apps.hi.baidu.com/share/detail/14317478>

 
 

sqlite外码问题

 
 

源文档 <http://topic.csdn.net/u/20100619/19/52cbd9b2-1396-4cf5-bf7d-7e2b851d0274.html>

 
 

 
 

SQLite 触发器的SQL语法

 
 

源文档 <http://wenku.baidu.com/view/d218d8eeaeaad1f346933fce.html>

 
 

SQLite "INSERT OR REPLACE INTO" vs. "UPDATE … WHERE"

 
 

源文档 <http://stackoverflow.com/questions/2251699/sqlite-insert-or-replace-into-vs-update-where>

Comments

Post a Comment

Popular posts from this blog

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

below is my mysql(MariaDB) server stored procedure code # call `pkrss_get_rssitem_vo`(2, 0, 0, 0, 1, 0, 0, 0); # flag = 1: select items # flag =-1: select items count # flag = 2: select items with image mode # flag =-2: select items with image mode count # flag = 3: get top 1 item with each table # flag = 4: get top n item with each table CREATE PROCEDURE `pkrss_get_rssitem_vo`(IN `lid` INT, IN `cid` INT, IN `tid` INT, IN `offset` INT, IN `limit` INT, IN `idOrderBy` INT, IN `timeOrderBy` INT, IN `flag` INT) BEGIN DECLARE s VARCHAR(512); DECLARE s2 VARCHAR(512); DECLARE t VARCHAR(128); DECLARE selImgMode INT DEFAULT 0; DECLARE selCountMode INT DEFAULT 0; IF flag = -1 THEN SET selCountMode = 1; END IF; IF flag = -2 THEN SET selCountMode = 1; SET selImgMode = 1; END IF; IF flag = 2 THEN SET selImgMode = 1; END IF; SET s = ''; IF selCountMode = 1 THEN SET s = CONCAT(s,'S...
Read more

2011-11

01 I need lean english from now on by self-learnt.   what are depression(沮丧) days! some many things need I fixed. liked:friends married,production to be bad,goal is losing,society is blackness,pressure come from many ways,money to earn…. pkrss need me to implement,girlfriend need me to find,caused need me to worked hardly, knowledge need me to learnt,living need me to live. ok,you are right,I am a stubborn(顽固) old man.who are 28ages, and hardly communicate to another one.who are be imagined(想像) by adhere to self-view(坚持自我观点),who are prevent another continue to work in many timers. Always silence, not to many saying..  because i  think that is wasting. Good , I will work hardly.   02 cy is leaving from fz,go to xm,why 10 silverlight 5 is not good, xaml is not good edit in blend 5,blend has some bug, not good run in many computers. I want to found some hyperlink control in web, liked in : http://gallery.expression.microsoft.com 20 when I research silver...
Read more

php openid test log

1.test examples/discover.php 1.1 error when i test http://localhost/t/php-openid/examples/discover.php and used bellow for "Enter an OpenID URL to begin discovery": http://localhost/t/php-openid/examples/server/server.php ,get this error: Got no response code when fetching https: //localhost:80/t/php-openid/examples/server/server.php/idpXrds CURL error (35): error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol fixed: then i changed above URL to: https://localhost/t/php-openid/examples/server/server.php 1.2 error then get bellow error message: Got no response code when fetching https: //localhost/t/php-openid/examples/server/server.php CURL error (60): SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed fixed: add one line in php-openid\Auth\Yadis\ParanoidHTTPFetcher.php line:130 curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false );
Read more