sqlite常用语句

-- SELECT * FROM yanyou_copy1 ORDER BY CAST(ctime AS INT) LIMIT 0,10 
SELECT  * FROM yanyou_copy1 ORDER BY CAST(ctime AS INT ) DESC LIMIT 0,10 

-- SELECT COUNT(*) FROM yanyou_copy1 
-- where cid = '211'

-- select *
-- from yanyou
-- where content like '%他出去方便一下%' 
-- SELECT * FROM yanyou WHERE cid = '205'


-- CREATE TABLE head
--        (
--              id INTEGER PRIMARY KEY AUTOINCREMENT,
--              pic              TEXT,
--              intro            TEXT
--        )

--  INSERT OR IGNORE INTO head (pic,intro) VALUES ('http://img2.kybimg.com/broadcast/201901/2c4ea9eaab37fc2ccca9a0019cc21ded.jpg','不念过往，不为未来，珍惜现在。')
--  INSERT OR IGNORE INTO head (pic,intro) VALUES (‘http://img2.kybimg.com/broadcast/201901/a061ef8029778405fd0e43b7bbc04291.jpg’,‘就算路不坦荡，也要做自己的太阳！’)


-- select *
-- from head
-- where intro like '%这是你所拥有的时间，这是你能决定的生活%' 

-- DELETE
-- FROM head
-- WHERE id > 1000