Re: [sqlite] Best practices for create derived SQLite tables

On 2 Jun 2013, at 8:26pm, James Mahon wrote: > I'm trying to find the best method to create new tables in SQLite derived > from a select statement on an existing SQLite table. I've currently tried > the two methods, one in Python and one in the SQLite command shell

[sqlite] Best practices for create derived SQLite tables

Hello, I'm trying to find the best method to create new tables in SQLite derived from a select statement on an existing SQLite table. I've currently tried the two methods, one in Python and one in the SQLite command shell (both illustrated below). Although I generally prefer to code in Python, I