I have a fairly complex sqlite database with several tables and indices. I'd like to copy a small subset of all the rows into a new database that I can use to test an app. Is there any builtin export functionality that can do something like that? eg. .clone db where titles.id < 100;


  • typically you would just write the scripts to do this. – Hogan Aug 11 '15 at 15:44
  • thanks, ya just wondering if there's a sqlite cli command for this. – 4m1r Aug 11 '15 at 17:54
  • I think a combination of .export and head would work well – Hogan Aug 11 '15 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.