sqlite 操作记录。

SELECT word, sentenceEn FROM allSentence WHERE word="access" AND sentenceEn="Users can access their voice mail remotely." 
SELECT word, phaseEn FROM allPhase WHERE word="access" AND phaseEn="access control" 
SELECT word, homologousEn FROM allHomologous WHERE word="access" AND homologousEn="accessible" 
SELECT word, synonymEn FROM allSynonym WHERE word="access" AND synonymEn="make use of" 
SELECT word, transEn FROM allTrans WHERE word="access" AND transEn="to find information, especially on a computer" 
SELECT word, remember FROM allRemember WHERE word="access" AND remember="ac ＋ cess(去) → 来去要走通道 → 通道" 

UPDATE allTrans SET transCn=NULL WHERE transCn="/"

SELECT transCn FROM allTrans WHERE transCn="/"

SELECT transCn FROM allTrans WHERE transCn like "%/%"

update allTrans SET transCn=replace(transCn,"/",".")

UPDATE allBookList SET tag1="aa" WHERE bookId="CET4luan_1"

INSERT INTO allFavourite (word) VALUES ("aaa")

DELETE FROM allFavourite WHERE word="aaa"

SELECT bookName FROM allBookList WHERE bookName like "%SAT%" OR tag1 like "%八%"

SELECT word FROM allWord WHERE word like "%a%%a%%b%%c%%a%"

UPDATE allTrans SET transCn=NULL WHERE transCn='"'