SQLiteSpy_1.7.9.zip_SQLite 工具_SQLiteSpy_sqlite_数据库 工具_查看 sqlite

--select * from myTab1 where des like '%b%' --select * from myTab1 where des = '第一名' --insert into myTab1(id, des) values(3, 'abc') --select * from (select * from myTab1 limit 3) order by id desc limit 1 --select * from myTab1 limit 1 offset 6 select * from myTab1 limit 2,1