Sqlite3 笔记

CREATE TABLE IF NOT EXISTS table (...);

id INTEGER PRIMARY KEY [AUTOINCREMENT] --AUTOINCREMENT加不加id都会自动增加

SELECT * FROM example WHERE id IN('38','34','39','36','37') ORDER BY INSTR('38,34,39,36,37',id);