1 单条语句插入多条记录
INSERT INTO TABLE(col1, col2) SELECT val11, val12 UNION ALL SELECT val21, val22 ;
例子:
sqlite> INSERT INTO people(sex, name) SELECT "female", "wang gang" UNION ALL SELECT "male", "li gang" ;
select * from CALL_ANA where prefix like substr("345678",1,length(prefix))||'%' and (maxlen>= 6 and minlen<=6 and ldsetid = (select ldsetid from Extensions where extension = "1000")) order by length(prefix) DESC